import large XML to oracle DB

I would like to play with Stack Overflow's data dump in Oracle. The format that they gave me is in XML and it is very very huge (one XML file is about 3GB). I would like to do an import of this data to my Oracle DB. I know one other guy in this topic managed to work开发者_C百科 on it using the XML directly. Any ideas or suggestions to make this happen easily?

Check out the groovy SQL and XML libraries--you should be able to get up and running pretty quick even with minimal Java/Groovy experience.

http://docs.codehaus.org/display/GROOVY/Tutorial+6+-+Groovy+SQL

Groovy XML

You'll need to install groovy and get the ojdbc14.jar drivers from Oracle. Put your code in a file and run:

groovy -cp ojdbc14.jar myscript.groovy