This content has been marked as final. Show 2 replies
Couple of Questions ?
Which verson of the database...
Are you using the XML DB repository to provide path based access to the XML Content.
1. You cannot break the associated between a table and it's schema..
So if I understand waht you want to do you will have to do something different..
Copy the data into a non schema based table (Either XMLType Store AS CLOB or XMLType store as SecureFile Binary XML).
YOu probably want to invoke the createNonSchemaBasedXML() operator when inserting the XML non schema based table.
Once all the data is copied, delete and purge the local schema, and all of it's types and tables.
Create a new table based on the Global Schema.
Copy the database back into the new table..
I know two data copies are a PITA, but I can think of no other way of doing this. The Schema Based XML representation contains references that can only be decoded by using the XML Schema that was used to encode the references. This appies to both Schema Based Binary XML and Object Relational Storage.