Generate DB schema and load data based on XML file?

We have a large XML file with lots of data relationships and lots of data. Is there a way to generate a DB schema based on the relationships an开发者_开发知识库d then load the data into the schema?

Just write an XSLT which would generate schema in SQL.
Then write another XSLT which would generate INSERT statements.

Stuff like this can be found on the Oracle OTN XMLDB Forum. This one is mentioned here: Generate XML Schema from oracle tables