Oracle DB Link관리

• DBA

DBLINK 생성 구문

SQL> CREATE [PUBLIC] DATABASE LINK link_name
         [CONNECT TO CURRENT_USER]
         [USING 'connect_string']
 
SQL> CREATE DATABASE LINK 링크이름
         CONNECT TO <연결하고자 하는 user>
         IDENTIFIED BY <연결하고자 하는 USER password>
         USING '원격 db alias'
 
CREATE DATABASE LINK HWS
         CONNECT TO schema_name IDENTIFIED BY "schema_password"
         USING '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=server_address)(PORT = 1521))(CONNECT_DATA=(SERVER = DEDICATED)(SERVICE_NAME = ORCL)))'
;
DROP DATABASE LINK HWS;