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/06/21 12:04 by 127.0.0.1