用impdp导入数据
在数据库下：
CREATE DIRECTORY DX_DIR AS 'G:\TEST\';
在cmd执行：
impdp dxjf/a directory=dx_dir dumpfile=CALL_TICKET_TIMESPA.DMP tables=call_ticket,ACCT,
ACCT_ITEM,ACCT_ITEM_DISCT,ACCT_ITEM_TYPE,ALL_DISCT_TOTAL,ALL_DIST_TAB,AREA_CODE,
BILLING_CYCLE,BILLING_CYCLE_TYPE,BILLING_TYPE,CALL_TICKET,CARDNO,CARDNO_PREFIX,CUST,
CUST_DISCT,CUST_MONTH_ACT_COST_T,DISCT_RULE,EXCHANGE,FIRSTNAME,FLAT_LATN_CALL_TARIFF,
HOLIDAY,LASTNAME,LATN,LATN_CALL_TARIFF,LOCAL_TICKET_TYPE,MOBILE,NO_CUST_TICKET_CALL,
NO_CUST_TICKET_CALL_T,SERV,SERV_DISCT,SERV_TYPE,TAB_CUST_DIST_AMOUNT,TARIFF_TIME_SPAN,
TARIFF_TYPE,TEMP_BASE_TARIFF,TICKET_ACCT_ITEM,TICKET_TYPE,TIME_SPAN,URTYPE_CHARGE,USAGE_CHARGE,
ACCT_SEQUENCE job_name=aa
在数据库下：
CREATE DIRECTORY DX_DIR AS 'G:\TEST\';
在cmd执行：
impdp dxjf/a directory=dx_dir dumpfile=CALL_TICKET_TIMESPA.DMP tables=call_ticket,ACCT,
ACCT_ITEM,ACCT_ITEM_DISCT,ACCT_ITEM_TYPE,ALL_DISCT_TOTAL,ALL_DIST_TAB,AREA_CODE,
BILLING_CYCLE,BILLING_CYCLE_TYPE,BILLING_TYPE,CALL_TICKET,CARDNO,CARDNO_PREFIX,CUST,
CUST_DISCT,CUST_MONTH_ACT_COST_T,DISCT_RULE,EXCHANGE,FIRSTNAME,FLAT_LATN_CALL_TARIFF,
HOLIDAY,LASTNAME,LATN,LATN_CALL_TARIFF,LOCAL_TICKET_TYPE,MOBILE,NO_CUST_TICKET_CALL,
NO_CUST_TICKET_CALL_T,SERV,SERV_DISCT,SERV_TYPE,TAB_CUST_DIST_AMOUNT,TARIFF_TIME_SPAN,
TARIFF_TYPE,TEMP_BASE_TARIFF,TICKET_ACCT_ITEM,TICKET_TYPE,TIME_SPAN,URTYPE_CHARGE,USAGE_CHARGE,
ACCT_SEQUENCE job_name=aa
expdp 数据泵导出
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/31402276/viewspace-2127104/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
直方图
请登录后发表评论
登录
全部评论
