XML Schema registration behaving differently in latest release (11.2.0.2) and causing problems
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.