oracle DBLink

-- 1.创建dblink

--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