Ora-2354 Ora-1006 On Expdp

(Doc ID 758372.1)

Last updated on DECEMBER 26, 2008

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.2
This problem can occur on any platform.

Symptoms

Problem reported on early versions of 10.2.x.   This is reproduced on an occassional basis, making the problem difficult to narrow down and diagnose. 

Expdp parameters:
JOB_NAME='EXPORT_dwhprd_$DATE and TIME$'
LOGFILE=PUMPDIR:dwhprd_expdp200807170420.log
DUMPFILE=PUMPDIR:dwhprd_expdp_%U_200809141440.dmp - again DATE and TIME
PARALLEL= 4
DIRECTORY=PUMPDIR
FILESIZE=2000M
SCHEMAS=
ACUPRD
BOSGEN
BATPRD
BODPRD
BOQPRD
BOUPRD
DSLPRD
DWH
STG
EXCLUDE=MATERIALIZED VIEW,MATERIALIZED_VIEW_LOG,DIMENSION
EXCLUDE=table:"like 'FTT%'"
EXCLUDE=table:"like 'MV%'"
EXCLUDE=table:"like 'MLO%'"

Source and Target are on the same database release level

Registry components in source database -> all VALID
Size of export Data Pump dump file : around 20G

==> from dwhprd_dm00_19188.trc

KUPM: 04:58:44.047: Current user is: EXP_USER
KUPM: 04:58:44.047: Error message received from worker
DG,KUPC$C_1_20081014045539,KUPC$A_1_20081014045732,MCP,134,Y error count = 3 last_message = 1
KUPM: 04:58:44.051: ORA-31694: master table "EXP_USER"."EXPORT_DWHPRD_200810140455" failed to
load/unload
ORA-02354: error in exporting/importing data
ORA-01006: bind variable does not exist
KUPM: 04:58:44.051: ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 6208
KUPM: 04:58:44.051: ----- PL/SQL Call Stack -----
object line object
handle number name
c00000032a32a1b0 14916 package body SYS.KUPW$WORKER
c00000032a32a1b0 6300 package body SYS.KUPW$WORKER
c00000032a32a1b0 2710 package body SYS.KUPW$WORKER
c00000032a32a1b0 6875 package body SYS.KUPW$WORKER
c00000032a32a1b0 1262 package body SYS.KUPW$WORKER
c00000032b720338 2 anonymous block
KUPM: 04:58:44.052:

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms