Database Links

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

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;

Enjoyed this post? Share it!

 

Leave a comment

Your email address will not be published.