Would Like To Reverse-Engineer Some XML Schemas
We are using a 10.2.0.4.0 database, running on Windows 2003 R2 64-bit.
The goal: move the app schema from this database to an 11g database on Linux.
The issue: the app schema uses xml objects, and according to Oracle Support, the objects must be pre-created before impdp can insert the data.
We no longer have the scripts which originally created the xml schemas (naturally), so I'm hoping there is a way to do this by manually reverse-engineering an xml schema. Has anyone ever attempted this?
I have searched on the Web for examples, but every post I've seen has referenced that they used a tool such as Visio or ODI, etc. Alas, I don't have access to any tools, and am hoping it can be done manually ..
Just curious as to whether or not anyone has ever attempted this.
Thanks for any insights.
Click Here to Expand Forum to Full Width