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