--create public database link ODS_DBLINK connect to ruccdta identified by "ruccdta" using '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.181.76.155)(PORT = 1541))) (CONNECT_DATA = (SERVICE_NAME = oradev) ))';
-- 2.导数据
INSERT INTO UNIONPAY_APMA (SELECT seq_unionpay_apma.nextval, a.* FROM UNIONPAY_APMA@ODS_DBLINK a);
-- 3.删除DBLink
DROP PUBLIC DATABASE LINK ODS_DBLINK;
-- 另外,在控制台执行存储过程时,把控制台打印启动的语句为:
SET SERVEROUTPUT ON;
EXECUTE validate_count; -- 执行一个存储过程
-- 在命令行用slqplus登录数据库并执行脚本,保存日志文件:
sqlplus wbps/wbps@bddb:1521/orcl @C:\unionpay_migration\20140716_unionpay_data_migration.sql> C:\unionpay_migration\out.log