Data Pump Import (Impdp) Fails with ORA-31000: Resource 'XXXXXXXXXX.xsd' is not an XDB schema document
(Doc ID 1937363.1)
Last updated on AUGUST 25, 2023
Applies to:
Oracle Database Exadata Express Cloud Service - Version N/A and laterOracle Database Cloud Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Oracle Database Cloud Schema Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
Impdp ifailed with the following errors:
nohup impdp "'/ as sysdba'" parfile=impdpCCDR_APP_SITR3_REPO.par >MyOutput_CCDR_APP_SITR3_REPO.log 2>&1 &
ORA-39083: Object type XMLSCHEMA failed to create with error:
ORA-31000: Resource 'XXXXXXXXX.xsd' is not an XDB schema document
Failing sql is:
BEGIN dbms_xmlschema.registerSchema(:1, :2, (:3 = 1), FALSE,FALSE,FALSE,FALSE, :4, options=> :5, schemaoid => :6, import_options => :7); END;
ORA-39083: Object type XMLSCHEMA failed to create with error:
ORA-31000: Resource 'XXXXXXXXX.xsd' is not an XDB schema document
Failing sql is:
BEGIN dbms_xmlschema.registerSchema(:1, :2, (:3 = 1), FALSE,FALSE,FALSE,FALSE, :4, options=> :5, schemaoid => :6, import_options => :7); END;
ORA-31000: Resource 'XXXXXXXXX.xsd' is not an XDB schema document
Failing sql is:
BEGIN dbms_xmlschema.registerSchema(:1, :2, (:3 = 1), FALSE,FALSE,FALSE,FALSE, :4, options=> :5, schemaoid => :6, import_options => :7); END;
ORA-39083: Object type XMLSCHEMA failed to create with error:
ORA-31000: Resource 'XXXXXXXXX.xsd' is not an XDB schema document
Failing sql is:
BEGIN dbms_xmlschema.registerSchema(:1, :2, (:3 = 1), FALSE,FALSE,FALSE,FALSE, :4, options=> :5, schemaoid => :6, import_options => :7); END;
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 |
| Cause |
| Solution |
| References |