User Tools

Site Tools


tech:rdbms:ora_dblinks

Oracle Database Links

Create db link:

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

Example:

create public database link STAGE 
connect to STAGE identified by STAGE 
using 'aos.su.local:1521/AOS'

Drop db link:

drop public database link <LINK_NAME>;

Example:

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 127.0.0.1

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