Description: Database Links are used to communicate between different databases.
Comment: (none)
Language: Highlight Mode: PLSQL Last Modified: March 06th, 2009
How TOVIEW existing database links
SELECT*FROM user_db_links;SELECT*FROM all_db_links;CREATE a PUBLIC Database Link
conn /AS sysdba
CREATEPUBLIC DATABASE LINK publink
USING 'public_link';CLOSE a database link
ALTER SESSION CLOSE DATABASE LINK test1_link;DROP a database link
DROP DATABASE LINK test1_link;