从A库查询记录,插入B库,首先进行连接:
create database link FMDM
connect to FMDM
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)(HOST = 100.89.1.40)(PORT = 1521)
)
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)';
再插入:
INSERT INTO table@FMDM
(
CODE,
NAME,
TEL,
PYCODE,
DCODE,
COMMENT1
)
SELECT
CODE,
NAME,
TEL,
PYCODE,
DCODE,
COMMENT1
FROM yp_sup;