I have a large XML Schema (18,500+ Lines) that I am trying to import into Oracle's XML DB, and I am running into the problem that there are about 10,000 refs declared in the schema. The problem with Refs is that XML DB does not know what these columns are pointing at, so instead of making them columns in the table based on their datatype they make a new table using a large object as the only column. This means that if I run the schema as is, I will get some 200 tables just for the structure of the schema, then an extra 10,000 tables to accomidate all of the refs, some of which are pointing at a simple Boolean datatype. Is there some tool out there, or does anyone have any suggestions on the easiest way to convert refs in an XML Schema to types? I really dont care how it does it, as long as it gets rid of the refs.
Thank you,
Tim
Thank you,
Tim