CODEWITHSUNDEEP
sqlxmloracle-database
aherlambang
aherlambang

Reputation: 14418

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 on it using the XML directly. Any ideas or suggestions to make this happen easily?

Upvotes: 1

Views: 1408

Answers (1)

Justin Thomas
Justin Thomas

Reputation: 5848

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

Upvotes: 1

Related Questions