| Loading large XML-Files into 9i [message #91927] |
Thu, 25 September 2003 09:03  |
Ivan Brozicevic
Messages: 1
Registered: September 2003
|
Junior Member |
|
|
Hi,
for analysis purposes we have to design and create reporting Servers using oracle 9.2.
Now I am evaluating the best way to load large amount of XML-data into the database.
I was able to load some XML-Files into the database. But the performace is quite terrible for our purposes.
The first approch was to use the XMLType CLOB. I also tried the Structured XML Storage.
In both cases I used java to load the Files into the database.
I'm not shure, if storing large amount of XML data into database is "the way" for me.
In next steps I have also to process this data in acceptable time. It could be a problem.
Now we are thinking about a way to take XML Files, parse it and store the Data into a relational table.
Somthing like oracle Loader for XML.
I would be thankful for any hints.
|
|
|
|
| Re: Loading large XML-Files into 9i [message #126788 is a reply to message #91927] |
Wed, 06 July 2005 11:40  |
sapnaoracle
Messages: 3
Registered: June 2005
|
Junior Member |
|
|
hi,
I ahve seen your question and wanted to know the solution u found out because I am asigned a similar task of loading xml data file into oracle .I am thinking of using sqlloader because the load is not too large.
Can u give me ur opinion plzz.
Thank you,
Sapna
|
|
|
|
| Re: Loading large XML-Files into 9i [message #157544 is a reply to message #126788] |
Fri, 03 February 2006 02:18 |
lokeya
Messages: 2
Registered: January 2006
|
Junior Member |
|
|
To load xml files into the database(CLOB column is this is where you want to put your xml) use: DBMS_LOB.LoadCLOBFromFile() to do the job.
It does the following :
Reads the files which you have placed in a dir in ur OS.
Use the above method and insert into the CLOB column in the DB.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
