Oracle对Oracle的链接:
创建:
CREATE PUBLIC DATABASE LINK linkname
CONNECT TO username IDENTIFIED BY password
USING ‘tnsname’
删除:
DROP PUBLIC DATABASE LINK linkname
Oracle对Oracle的insert demo:
insert into seq_head
SELECT A.*,'HUB' from seq_head@histest A;
Oracle对Oracle的链接:
创建:
CREATE PUBLIC DATABASE LINK linkname
CONNECT TO username IDENTIFIED BY password
USING ‘tnsname’
删除:
DROP PUBLIC DATABASE LINK linkname
Oracle对Oracle的insert demo:
insert into seq_head
SELECT A.*,'HUB' from seq_head@histest A;