User Tools

Site Tools


Oracle Database Links

Create db link:

create public database link <LINK_NAME> 
connect to <USER> identified by <PASS> 
using '<HOST>:<PORT>/<SID>';


create public database link STAGE 
connect to STAGE identified by STAGE 
using ''

Drop db link:

drop public database link <LINK_NAME>;


drop public database link STAGE;

List all db links:

select * from dba_db_links;
tech/rdbms/ora_dblinks.txt · Last modified: 2024/02/21 19:09 by

Except where otherwise noted, content on this wiki is licensed under the following license: Public Domain
Public Domain Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki