ORA-19007: Schema - Does Not Match Expected (Doc ID 1487551.1)

Last updated on FEBRUARY 08, 2017

Applies to:

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

Symptoms

Getting error:

  ORA-19007: Schema - does not match expected http://www.staffware.com/frameworks/schema/ExecutionPlan.xsd.

While trying to import a table that conforms to an xml schema

Later on during the import the analyze table errors out with an ORA-00600 [qctoxmlxdty]

 "ANALYZE TABLE "EXECUTIONPLAN" ESTIMATE STATISTICS "
IMP-00003: ORACLE error 600 encountered
ORA-00600: internal error code, arguments: [qctoxmlxdty], [], [], [], [], [], [], []
Import terminated successfully with warnings.


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Data Mining and Real Application Testing options

Export file created by EXPORT:V10.02.01 via direct path
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
. importing OPS$ORACLE's objects into OPS$ORACLE
. importing BTO_TIBCO's objects into BTO_TIBCO
. . importing table "primaryKey102_TAB" 0 rows imported
. . importing table "slas126_TAB" 0 rows imported
. . importing table "characteristics125_TAB" 0 rows imported
. . importing table "UDFs124_TAB" 0 rows imported
. . importing table "component137_TAB" 0 rows imported
. . importing table "clearDependencyValues177_TAB" 0 rows imported
. . importing table "dependency176_TAB" 0 rows imported
. . importing table "actions175_TAB" 0 rows imported
. . importing table "processVersion181_TAB" 0 rows imported
. . importing table "process185_TAB" 0 rows imported
. . importing table "executionPlan207_TAB" 0 rows imported
. . importing table "task206_TAB" 0 rows imported
. . importing table "summary205_TAB" 0 rows imported
. . importing table "orchSubject222_TAB" 0 rows imported
. . importing table "basic221_TAB" 0 rows imported
. . importing table "manager220_TAB" 0 rows imported
. . importing table "PROCESS" 60 rows imported
. . importing table "COMPONENT" 14 rows imported
. . importing table "EXECUTIONPLAN"
IMP-00058: ORACLE error 19007 encountered
ORA-19007: Schema - does not match expected http://www.staffware.com/frameworks/schema/ExecutionPlan.xsd.
IMP-00028: partial import of previous table rolled back: 36 rows rolled back
. . importing table "ORCHSUBJECT" 34660 rows imported
. . importing table "SCHEDULED_EVENTS" 3 rows imported
. . importing table "ORDERS" 530 rows imported
IMP-00017: following statement failed with ORACLE error 600:
 "ANALYZE TABLE "EXECUTIONPLAN" ESTIMATE STATISTICS "
IMP-00003: ORACLE error 600 encountered
ORA-00600: internal error code, arguments: [qctoxmlxdty], [], [], [], [], [], [], []
Import terminated successfully with warnings.

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