SQL Loader.

[Quoted] [Quoted] Could somebody assist me with extraction from an Oracle database.

I have no knowledge of SQL Loader bar the past 3 hours frantically trying to accumulate some knowledge; therefore any assistance would be gratefully appreciated.

The problem we are having is with extracting data from an Oracle financials system and therefore we require a large amount of records extracted (with all fields) from an invoices file.

The last extraction we received had a line length of 400 so we had many records wrapping around multiple lines and a resulting file of 5gb. In order to "fix" this (bear with me) a line length has been set up of 10000, causing the latest file sent to us to be 104gb in size.

The question therefore is can an extraction be set with a "maximum linesize" allowing the extract to not waste so much space. If this is impossible using SQL Loader a reply to that effect would also be helpful.

Thanks very much in advance.
Kevin Gurney. Received on Tue Sep 18 2001 - 17:58:07 CEST