XML to DB - what is the best way ?

XML to DB - what is the best way ?

Postby David14 » Sat 08 Jan 2005 21:54

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.
David14
 

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

Postby Oleg » Mon 10 Jan 2005 16:11

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.
Oleg
Devart Team
 
Posts: 264
Joined: Thu 28 Oct 2004 13:56


Return to dotConnect for Oracle