Page 1 of 1

XML to DB - what is the best way ?

Posted: Sat 08 Jan 2005 21:54
by David14
Hello,

What is the fastest/effective way to extract XML data from big files (100MB) into Oracle database ?

Is writing the data to text files first, and then loading it via SQL-Loader is an effective way ?

Thanks.

Re: XML to DB - what is the best way ?

Posted: Mon 10 Jan 2005 16:11
by Oleg
You can load large text data in CLOB to the server for further it processing.
You can process this data on client side and load to the server using OracleLoader component.