一、问题kydsp
expdp通过parfile导数时候报错如下:
ORA-39194: Table mode jobs require the tables to be comma separated.
相关脚本为:
userid='sys/uyeer432@pnccist as sysdba'directory=LZLLdumpfile=expdp_%Y%M%U.dmplogfile=expdp.logjob_name=expdp1101version=10.2.0.5.0tables=('ECISINS.PRPCVATINFO','ECIS.PRPCVATINFO','ECIS.PRPCUSTSTATISTICS','ECIS.PRPPTEXT','ECIS.PRPDPOLICYCHGLOG','ECIS.PRPDCLASS','ECIS.PRPDCODE','ECIS.PRPDCOMPANY','ECIS.PRPDCURRENCY','ECIS.PRPDEXCH','ECIS.PRPDKIND','ECIS.PRPDRISK','ECIS.PRPDUSER','ECIS.PRPLCLAIM','ECIS.PRPLCLAIMLOSS','ECIS.PRPLCOMPENSATE','ECIS.PRPLPAYMETHOD','ECIS.PRPLPERSON','ECIS.PRPLREGIST','ECIS.PRPLRELATEPERSON','ECIS.PRPDFORMULA','CCTEST.CRM_CASE_INFO','CCTEST.CRM_CASE_CANCEL','CCTEST.CRM_COMPLAINT','CCTEST.CRM_CASCADE_MENU','CCTEST.CRM_CONSULTATION','CCTEST.CRM_RESERVATION_FEE','CCTEST.CRM_OBJECTION','CCTEST.CRM_RESCUE_ORDER','CCTEST.CRM_REPORT_INFO','CCTEST.CRM_URGE_CLAIM','CCTEST.CRM_URGE追寻的宝贝CAMPAIGN_TASK','CCTEST.CRM_CUSTOMER_BASE','CCTEST.CRM_URGE过时的龙猫URGE_PROSPECT','CCTEST.CRM_URGE_PROSPECT_SUPPLY','PPLS.PRPLACCIDENTCASERELATED','PPLS.PRPLACCIDENTINFO','PPLS.PRPLCLAIM','PPLS.PRPLCLAIMLOSS','PPLS.PRPLCLAIMLOSSITEMS','PPLS.PRPLCMAIN','PPLS.PRPLCOMPENSATE','PPLS.PRPLLOSS','PPLS.PRPLPAYINFO','PPLS.PRPLPAYINFOLIST','PPLS.PRPLPAYMETHOD','PPLS.PRPLPERSON','PPLS.PRPLREGIST','PPLS.PRPLRELATEPERSON','PPLS.PRPLCAR','CCOC_INTEG.PPLS.PRPLCARDRIVER','CCOC_INTEG.T_PA_PHEAD', ? ? ? ? ? ? ?'CCOC_INTEG.T_PA_CMAIN', ? ? ? ? ? ?'CCOC_INTEG.T_PA_CMAINEXTENSION', ? ??'CCOC_INTEG.T_PA_CMAINRELATION', ? ??'CCOC_INTEG.T_PA_CAPPNT', ? ? ? ? ? ?'CCOC_INTEG.T_PA_CINSUREDPERSON', ? ??'CCOC_INTEG.T_PA_CINSUREDITEMPERSON',?'CCOC_INTEG.T_PA_CITEM_KIND',?'CCOC_INTEG.T_PA_CITEM_KINDEXT', ? ? ?'CCOC_INTEG.T_PA_CITEMCAR', ? ? ?'CCOC_INTEG.T_PA_CITEMCAROTHER','EVVIVBU_CONFIG.T_DD_BUSI_DATA_TABLE','EVVIVBU_CONFIG.T_DD_BUSI_DATA_TABLE_RECORD','EVVIVBU_CONFIG.T_PRD_PRODUCT','EVVIVBU_CONFIG.T_PRD_PLAN_DEFINITION','EVVIVBU_CONFIG.T_PUB_EXCHANGE_RATE','EVVIVBU_CONFIG.T_PRD_PRODUCT_ELEMENT','EVVIVBU_CONFIG.T_PRD_PRODUCT_MASTER','OPE_YIERTY.T_PTY_BRANCH','OPE_YIERTY.T_PTY_PARTY','ECIS_UAT_PUB.T_PUB_USER','OPE_YIE.T_PA_PL_CUST_STAT','OPE_YIE.T_PA_PL_POLICY','OPE_YIE.T_PA_PL_INVOICE_INFO','OPE_YIE.T_PA_DATA_PATCH_LOG','OPE_YIE.T_PA_EDS_ENDORSEMENT')执行脚本报错如下:
[oracle@tstdb02 $ expdp parfile=expdp_evis.par
Export: Release 12.2.0.1.0 - Production on Fri Nov 9 09:27:42 2018
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
ORA-39194: Table mode jobs require the tables to be comma separated.
[oracle@tstdb02 ]$
二、解决方案:
DataPump TABLES Export Fails WIth Error ORA-39194 (文档 ID 1304286.1)
APPLIES TO:Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.2.0.2 - Release: 10.2 to 11.2
Information in this document applies to any platform.
You need to export a larger number of tables/partitions (i.e. hundreds), so you need to use the TABLES parameter in a DataPump parameter file. For example, the file (exp.par) may look like this.
directory=dpump_dir
dumpfile=dpump_dir:exp.dmp
logfile=dpump_dir:expdp.log
parallel=16
transportable=always
TABLES=(
USER1.TABLE1:P20080101,
USER1.TABLE1:P20080102,
USER1.TABLE1:P20080103,
....NOTE: entire list has not been included
USER1.TABLE1:P20081029,
USER1.TABLE1:P20081030,
USER1.TABLE1:P20081031
)
$ expdp system/manager parfile=exp.par
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
KUPM:16:02:10.751: DBMS_DATAPUMP.METADATA_FILTER (hand, 'TABLE_FILTER', 'USER1.TABLE1:P20080101,USER1.TABLE1:P20080102,USER1.TABLE1:P20080103,
USER1.TABLE1:P20080104,USER1.TABLE1:P20080105,USER1.TABLE1:P2
KUPM:16:02:10.751: 0080106,USER1.TABLE1:P20080107,USER1.TABLE1:P20080108,USER1.TABLE1:P20080109,
USER1.TABLE1:P20080110,USER1.TABLE1:P20080111,USER1.TABLE1:P20080112,
USER1.TABLE1:P20080113,USER1
KUPM:16:02:10.751: .TABLE1:P20080114,USER1.TABLE1:P20080115,USER1.TABLE1:P20080116,
USER1.TABLE1:P20080117,USER1.TABLE1:P20080118,USER1.TABLE1:P20080119,
USER1.TABLE1:P20080120,USER1.TABLE1
KUPM:16:02:10.751: :P20080121,USER1.TABLE1:P20080122,USER1.TABLE1:P20080123,
USER1.TABLE1:P20080124,USER1.TABLE1:P20080125,USER1.TABLE1:P20080126,
USER1.TABLE1:P20080127,USER1.TABLE1:P2008012
KUPM:16:02:10.751: 8,USER1.TABLE1:P20080129,USER1.TABLE1:P20080130,USER1.T...', cqdxz;
...
KUPM:16:02:11.202: Remaining trimmed filter: >USER1.TABLE1:P20080904,USER1.TABLE1.TABLE1.TABLE1.TABLE1.TABLE1.TABLE1.
TABLE1.TABLE1.TABLE1.TABLE1.TABLE1.TAB< KUPM:16:02:11.202: Element: USER1 Delimiter: .
KUPM:16:02:11.203: Element: TABLE1 Delimiter: :
KUPM:16:02:11.203: Element: P20080904 Delimiter: ,
Re-create the Data Pump Parameter file, preferably using the different method.
我这边重新保存文本解决问题