sys建立dblink连接,在连个库间导数据
sqlplus "/as sysdba"
---创建dblink连接
drop PUBLIC DATABASE LINK FAST_12;
CREATE PUBLIC DATABASE LINK FAST_12
CONNECT TO ZHEJIANG IDENTIFIED BY "zj*2016"
USING '(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.12)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SID = FAST) ) )';
----测试
select * from tab@fast_12;
conn zhejiang/"zj*2016"@192.168.1.12:1521/fast
----导数据
CREATE TABLE LTE_DT_RAWDATA AS SELECT * FROM LTE_DT_RAWDATA @FAST_12 WHERE 1=1;
sqlplus "/as sysdba"
---创建dblink连接
drop PUBLIC DATABASE LINK FAST_12;
CREATE PUBLIC DATABASE LINK FAST_12
CONNECT TO ZHEJIANG IDENTIFIED BY "zj*2016"
USING '(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.12)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SID = FAST) ) )';
----测试
select * from tab@fast_12;
conn zhejiang/"zj*2016"@192.168.1.12:1521/fast
----导数据
CREATE TABLE LTE_DT_RAWDATA AS SELECT * FROM LTE_DT_RAWDATA @FAST_12 WHERE 1=1;