Error ORA-31693 When Running Expdp
(Doc ID 1675006.1)
Last updated on AUGUST 02, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 10.1.0.2 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
When running a Datapump export, the following errors occur:
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 "<TABLE00>"
( "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 "<TABLE00>" 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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |