If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Would Like To Reverse-Engineer Some XML Schemas

Hi Folks,
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 ..