Posted By

mprabhuram on 07/07/10


Tagged

sql Oracle


Versions (?)

Create/ View/ Delete DB Links in oracle


 / Published in: SQL
 

URL: http://www.mydigitallife.info/2006/03/09/view-and-retrieve-oracle-database-link-details/

See the DBLinks that you have created in the past

  1. --Create DB Links
  2. CREATE DATABASE link "BUSDEV01"
  3. connect TO <uname>
  4. IDENTIFIED BY "<PASSWORD>"
  5. USING 'BUSDEV'
  6.  
  7. --View DB Links
  8. SELECT * FROM ALL_DB_LINKS
  9. WHERE USERNAME = '<uname>'
  10.  
  11.  
  12. --Delete DB Links
  13. DROP DATABASE LINK BUSUAT;

Report this snippet  

You need to login to post a comment.