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?
-
How do you want it in your Oracle database? A table with an XMLTYPE column? In relational format?Rob van Wijk– Rob van Wijk2011-03-23 09:58:33 +00:00Commented Mar 23, 2011 at 9:58
-
I want it in a relational formataherlambang– aherlambang2011-03-23 13:56:11 +00:00Commented Mar 23, 2011 at 13:56
-
1And what's wrong with the method shown by Vincent Malgrat in that other thread?Rob van Wijk– Rob van Wijk2011-03-23 13:59:08 +00:00Commented Mar 23, 2011 at 13:59
-
I don't know how to put the xml into the directory...aherlambang– aherlambang2011-03-23 15:58:54 +00:00Commented Mar 23, 2011 at 15:58
-
You just place the xml file somewhere on your server, you remember the OS directory you've put it in and you define an Oracle directory object on that OS directory.Rob van Wijk– Rob van Wijk2011-03-24 08:07:54 +00:00Commented Mar 24, 2011 at 8:07
Add a comment
|
1 Answer
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
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
