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