Advanced Search

Return to Snippet

Revision: 28318
at July 7, 2010 02:34 by mprabhuram
Updated Code 
--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;

Revision: 28317
at July 7, 2010 02:29 by mprabhuram
Updated Code 
SELECT * FROM ALL_DB_LINKS  WHERE USERNAME = 'XXXXXXX'

DROP [PUBLIC] DATABASE LINK link_name

Revision: 28316
at July 7, 2010 02:20 by mprabhuram
Initial Code 
SELECT * FROM ALL_DB_LINKS  WHERE USERNAME = 'XXXXXXX'
Initial URL 
http://www.mydigitallife.info/2006/03/09/view-and-retrieve-oracle-database-link-details/
Initial Description 
See the DBLinks that you have created in the past
Initial Title 
Create/ View/ Delete DB Links in oracle
Initial Tags 
sql, Oracle
Initial Language 
SQL