Posted By

mprabhuram on 07/07/10

Tagged

sql
Oracle

Versions (?)

Last Edited at 07/07/10 02:20am

Statistics

Viewed 790 times

Favorited by 0 user(s)

Related snippets

Create/ View/ Delete DB Links in oracle

/ Published in: SQL

See the DBLinks that you have created in the past

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

--Create DB Links
    CREATE DATABASE link "BUSDEV01"
    CONNECT TO <uname>
    IDENTIFIED BY "<PASSWORD>"
    USING 'BUSDEV'
 
    --View DB Links
    SELECT * FROM ALL_DB_LINKS 
    WHERE USERNAME = '<uname>'
 
 
    --Delete DB Links
    DROP DATABASE LINK BUSUAT;