Quick Search:
 
 Oracle PL/SQL: Database Links Jump to:  
Category: >> Oracle PL/SQL >> Database Links  

<< lastnext >>

Snippet Name: Database Links

Description: Database Links are used to communicate between different databases.

Comment: (none)

Language:
Highlight Mode: PLSQL
Last Modified: March 06th, 2009

How TO VIEW existing database links
 
SELECT * FROM user_db_links;
 
SELECT * FROM all_db_links;
 
 
 
CREATE a PUBLIC Database Link
 
conn / AS sysdba
 
CREATE PUBLIC 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;  


 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org