Hi Folks,
We are using a 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.