一、问题概述
expdp通过parfile导数时候报错如下:
ORA-39194: Table mode jobs require the tables to be comma separated.
相关脚本为:
userid='sys/uyeer432@pnccist as sysdba'
directory=LZLL
dumpfile=expdp_%Y%M%U.dmp
logfile=expdp.log
job_name=expdp1101
version=10.2.0.5.0
tables=('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_OTHERTYPE',
'CCTEST.CRM_CAMPAIGN_TASK',
'CCTEST.CRM_CUSTOMER_BASE',
'CCTEST.CRM_URGE_LOSSPRICE',
'CCTEST.CRM_URGE_PROSPECT',
'CCTEST.CRM_URGE_PROSPECT_SUPPLY',
'PPLS.PRPLACCIDENTCASERELATE