oracle12c 导入导出,数据导入导出 - oracle12c - twt企业IT交流平台

SELECT 'db2 export to /home/db2inst2/ufdata/data/'||tabname ||'.del of del select * from '||tabname

FROM syscat.tables WHERE  tabschema ='DB2INST1' AND TABNAME LIKE 'FC_%'

UNION

SELECT 'db2 connect to tsnc user db2inst1 using db2inst1 ' FROM DUAL

db2 import from S_LOAN.del of del insert into tmp_s_loan(ACCT_NO,ACCT_TYPE,BRANCH_CODE,CNTCT_NO,CUR_BAL,CURCY_CODE,CUST_CODE,DATA_DATE,INT_PMT_FRQ,ITEM_CODE,LN_RISK_CLASS,PROD_CODE)

db2 load from S_LOAN.del of del insert into tmp_s_loan(ACCT_NO,ACCT_TYPE,BRANCH_CODE,CNTCT_NO,CUR_BAL,CURCY_CODE,CUST_CODE,DATA_DATE,INT_PMT_FRQ,ITEM_CODE,LN_RISK_CLASS,PROD_CODE)

db2 "export to ${curr_path}/data/S_LOAN.del of del SELECT ACCT_NO,ACCT_TYPE,BRANCH_CODE,CNTCT_NO,CUR_BAL,CURCY_CODE,CUST_CODE,DATA_DATE,INT_PMT_FRQ,ITEM_CODE,LN_RISK_CLASS,PROD_CODE  FROM S_LOAN WHERE DATA_DATE ='2013-06-01'" >> ${curr_path}/log/run${preday}.log

CONNECT TO TSNC USER "db2inst1";

IMPORT FROM "C:UsersAdministratorDesktops_intnat_busi.txt" OF DEL MODIFIED BY NOCHARDEL COLDEL| METHOD P (1, 2, 3, 4, 5, 6, 7, 8, 9) MESSAGES "C:A" REPLACE INTO DB2INST1.S_INTNAT_BUSI (DATA_DATE, ACCT_NO, BRANCH_CODE, CUST_CODE, MGR_CODE, ITEM_ID, PROD_CODE, CURRENCY, CUR_BAL);

CONNECT RESET;

--导出数据库

db2move tsnc export

--导出指定用户下所有的的表

db2move tsnc export -tc db2inst1