Create/ View/ Delete DB Links in oracle


/ Published in: SQL
Save to your folder(s)

See the DBLinks that you have created in the past


Copy this code and paste it in your HTML
  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;

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

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.