Error ORA-31693 When Running Expdp (Doc ID 1675006.1)

Last updated on APRIL 24, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 and later
Information in this document applies to any platform.

Symptoms

When running a Datapump export, the following errors occur:

ORA-31693: Table data object "<schema-name"."<table-name>":"P01" failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-00554: error encountered while parsing access parameters
KUP-01005: syntax error: found "identifier": expecting one of: "double-quoted-string" etc..
KUP-01008: the bad identifier was: ku_quotXPRESSku_quot
KUP-01007: at line 1 column 35

 

The above sequence of error messages may occur numerous times for the same schema name/ table name combination.
The steps in <Note 1274563.1> have been followed, but the problem still persists.
Generating a Datapump export trace using TRACE=1FF0300 shows the following errors in the DWnn process trace file:


KUPD: 13:11:34.623: Size of PL/SQL statement is 994
KUPD: 13:11:34.623:  Statement is: CREATE TABLE "ET$015AA34F0001"
  ( "UID_NO",
"UID_DATE",
"UID_AUTHOR",
"INUID_NO",
"INUID_DATE",
"INUID_AUTHOR",
"EDNAME",
"RECEIVER",
"RECEIVERTYPE",
"MSGID",
"INTERF",
"REGION",
"DIRECTION",
"PROCESSTIME",
"STAGE",
"PROCDAY",
"TRANSPORTIDUFEBS"
  ) ORGANIZATION EXTERNAL
   ( TYPE ORACLE_DATAPUMP  DEFAULT DIRECTORY DUMPDP_DIR ACCESS PARAMETERS (DEBUG =3 DATAPUMP INTERNAL TABLE  ku_quotXPR            
ESSku_quot.ku_quotEDIMDOCku_quot  PARTITION  ku_quot P05 ku_quot JOB ( ku_quotXPRESSku_quot,ku_quotSYS_EXPORT_TABLE_01ku                       
_quot,1) WORKERID 1 PARALLEL 1 VERSION COMPATIBLE ENCRYPTPASSWORDISNULL ) LOCATION ('bogus.dat') )  PARALLEL 1 REJECT LI
MIT UNLIMITED
   AS SELECT "UID_NO", "UID_DATE", "UID_AUTHOR", "INUID_NO", "INUID_DATE", "INUID_AUTHOR", "EDNAME", "RECEIVER", "RECEI
VERTYPE", "MSGID", "INTERF", "REGION", "DIRECTION", "PROCESSTIME", "STAGE", "PROCDAY", "TRANSPORTIDUFEBS"
   FROM RELATIONAL("XPRESS"."EDIMDOC" )  PARTITION ( "P05" ) KU$ WHERE REGION=
15

KUPD: 13:11:34.623: Size of PL/SQL statement is 284
KUPD: 13:11:34.623:  Statement is: DECLARE
  stmt            VARCHAR2(2000);
  TABLE_NOT_EXIST exception;
  pragma          EXCEPTION_INIT(TABLE_NOT_EXIST, -942);
 BEGIN
   stmt := 'DROP TABLE "ET$015AA34F0001" PURGE';
   EXECUTE IMMEDIATE stmt;
 EXCEPTION  
   WHEN TABLE_NOT_EXIST THEN NULL;
 END;
) ORGANIZATION EXTERNAL
   ( TYPE ORACLE_DATAPUMP  DEFAULT DIRECTORY DUMPDP_DIR ACCESS PARAMETERS (DEBUG =3 DATAPUMP INTERNAL TABLE  ku_quotXPR             
ESSku_quot.ku_quotEDIMDOCku_quot  PARTITION  ku_quot P05 ku_quot JOB ( ku_quotEXPRESSku_quot,ku_quotSYS_EXPORT_TABLE_01ku                          
_quot,1) WORKERID 1 PARALLEL 1 VERSION COMPATIBLE ENCRYPTPASSWORDISNULL ) LOCATION ('bogus.dat') )  PARALLEL 1 REJECT LI
MIT UNLIMITED
   AS SELECT "UID_NO", "UID_DATE", "UID_AUTHOR", "INUID_NO", "INUID_DATE", "INUID_AUTHOR", "EDNAME", "RECEIVER", "RECEI
VERTYPE", "MSGID", "INTERF", "REGION", "DIRECTION", "PROCESSTIME", "STAGE", "PROCDAY", "TRANSPORTIDUFEBS"
   FROM RELATIONAL("XPRESS"."EDIMDOC" )  PARTITION ( "P05" ) KU$ WHERE REGION=
15

kuppwami:                                              ã04-30-2014 13:11:34.679…
       Entered - what am I, return process type.
KUPD: 13:11:34.682: Exception raised
KUPD: 13:11:34.683: Sqlcode is -29913
kuppgki:                                               ã04-30-2014 13:11:34.683…
       Entered - check interrupt queue for kupp interrupt.
KUPW: 13:11:34.684: 1: in procedure CREATE_MSG

KUPW: 13:11:34.684: 1: ORA-31693: Table data object "<schema-name>"."<table-name>":"P05" failed to load/unload and is being skipped
due to error:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-00554: error encountered while parsing access parameters
KUP-01005: syntax error: found "identifier": expecting one of: "double-quoted-string" etc..
KUP-01008: the bad identifier was: ku_quotXPRESSku_quot
KUP-01007: at line 1 column 35
KUPW: 13:11:34.686: 1: Just inserted message at duplicate : 1001
KUPW: 13:11:34.686: 1: in procedure SEND_MSG
KUPW: 13:11:34.686: 1: Error count is: 1
KUPC: 13:11:34.686: Before ENQ: Sending Type: 3032 ID: DG,KUPC$C_1_20140430131123,KUPC$A_1_20140430131125,MCP,22,Y
KUPW: 13:11:34.688: 1: ORA-31693: Table data object "<schema-name>"."<table_name>":"P05" failed to load/unload and is being skipped
due to error:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-00554: error encountered while parsing access parameters
KUP-01005: syntax error: found "identifier": expecting one of: "double-quoted-string" etc..
KUP-01008: the bad identifier was: ku_quotXPRESSku_quot
KUP-01007: at line 1 column 35

 

 

Changes

 None

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