DataPump Import (Impdp) Fails With ORA-39083 ORA-31000: Resource <voc_cardiac.xsd> Is Not An XDB Schema Document (Doc ID 1937363.1)

Last updated on AUGUST 12, 2017

Applies to:

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

Symptoms

Impdp import failed 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 'voc_cardiac.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 'ECG_voc.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

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