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.
XML to DB - what is the best way ?
Re: XML to DB - what is the best way ?
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.
You can process this data on client side and load to the server using OracleLoader component.