My Oracle Support Banner

Getting ORA-19007 when insert into schema based table (Doc ID 2867964.1)

Last updated on APRIL 17, 2023

Applies to:

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


Getting the below error after upgrading the database to 19c. The cursor was used to load data from the table with the oldest schema to a new table based on the new schema.

ORA-19007: Schema test_123.xsd does not match expected test_234.xsd.

The same was working on 11g/12c before. Asked to register xml schema as a global schema but still getting the same error.


Upgrading the database to 19c.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.