XML to DB - what is the best way ?

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
David14

XML to DB - what is the best way ?

Post by 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.

Oleg
Devart Team
Posts: 264
Joined: Thu 28 Oct 2004 13:56

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

Post by 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.

Post Reply