ORA-29913: error in executing ODCIEXTTABLEPOPULATE callout while expdp
KunwarApr 8 2011 — edited Apr 11 2011Hi all,
My below expdp command failing with the below error:
With the Partitioning and Data Mining options
Starting "TKSDBO53"."EXPDP_AR1_TAX_ITEM": TKSDBO53/********@INTKS10G tables=AR1_TAX_ITEM DUMPFILE=DUMP:Expdp_AR1_TAX_ITEM_%U.dmp LOGFILE=LOG:Expdp_AR1_TAX_ITEM.log CONTENT=DATA_ONLY FILESIZE=5G EXCLUDE=INDEX,STATISTICS,CONSTRAINT,GRANT PARALLEL=5 JOB_NAME=Expdp_AR1_TAX_ITEM
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 19.80 MB
ORA-31693: Table data object "TKSDBO53"."AR1_TAX_ITEM":"AMAXVALUE_BMAXVALUE" failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLEPOPULATE callout
ORA-00001: unique constraint (TKSDBO53.SYS_C00612451) violated
ORA-06512: at "SYS.KUPF$FILE", line 2580
ORA-06512: at line 1
. . exported "TKSDBO53"."AR1_TAX_ITEM":"AMAXVALUE_BMAXVALUE" 0 KB 324 rows
Master table "TKSDBO53"."EXPDP_AR1_TAX_ITEM" successfully loaded/unloaded
The command i am using is
expdp TKSDBO53/TKSDBO53@INTKS10G tables=AR1_TAX_ITEM DUMPFILE=DUMP:Expdp_AR1_TAX_ITEM_%U.dmp LOGFILE=LOG:Expdp_AR1_TAX_ITEM.log CONTENT=DATA_ONLY FILESIZE=5G PARALLEL=5 JOB_NAME=Expdp_AR1_TAX_ITEM2
> uname
Linux
SQL> select *from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi
PL/SQL Release 10.2.0.3.0 - Production
CORE 10.2.0.3.0 Production
TNS for Linux: Version 10.2.0.3.0 - Production
NLSRTL Version 10.2.0.3.0 - Production
Please suggest what should i do?
Regds,
Kunwar