16 lines
436 B
Markdown
16 lines
436 B
Markdown
|
#Oracle #오라클
|
|||
|
|
|
|||
|
|
DROP DATABASE LINK SAMBOANT_NAPREQ;
|
|||
|
|
|
|||
|
|
|
|||
|
|
CREATE DATABASE LINK SAMBOANT_NAPREQ
|
|||
|
|
CONNECT TO IZ_MOD
|
|||
|
|
IDENTIFIED BY <PWD>
|
|||
|
|
USING '(DESCRIPTION= (ADDRESS_LIST= (ADDRESS=(PROTOCOL=TCP)(HOST=222.251.186.41)(PORT=1521)) ) (CONNECT_DATA= (SID=ORCL) ) )';
|
|||
|
|
|
|||
|
|
CREATE DATABASE LINK TACEEZ_LINK
|
|||
|
|
CONNECT TO user1 IDENTIFIED BY user1 USING 'TEST155';
|
|||
|
|
|
|||
|
|
-- link 생성 권한 부여
|
|||
|
|
|
|||
|
|
GRANT CREATE DATABASE LINK TO ERPMAN ;
|