Thursday, November 19, 2009

Dblink Details

SELECT dl.owner
,dl.db_link
,dl.username login_name
,dl.host
,to_char(dl.created,'YYMMDD HH24:MI') crdate
FROM dba_db_links dl
ORDER BY dl.owner
,dl.db_link
at
Labels: ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Command to do active duplicate for Oracle Database

1. First login to target server 2. Validate tns connectivity between Source DB and Target DB 3. Prepare and validate space availability 4. S...