XML Database (MOSC)

MOSC Banner

XML Schema registration behaving differently in latest release (11.2.0.2) and causing problems

edited Dec 10, 2010 2:46AM in XML Database (MOSC) 1 commentAnswered
Problem Description:

We have a table with 1 xmltype column defined. On multiple systems running 11.2.0.1we have registered the associated XML schemas, and created the table without issue. When trying to do this on the latest DB, 11.2.0.2 (Same OS, etc) we have failures. A system generated "extra" reference table is being created, which is apparently blocking the creation of the table we desire. On creation I get the error:

ORA-19046: Out-of-line table cannot be shared by two top-level tables

Didn't find much info on this error. A search on it in the oracel knowledge base returns 0 results.

We are unaware of how to fix or work around this.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center