Re: SQL Loader.
Date: Tue, 18 Sep 2001 16:37:37 GMT
Message-ID: <3ba77415.31109343_at_news.btclick.com>
Hi Kevin
Some ideas :-)
Can you connect the two Oracle Databases via a DBlink?. If this is possible you can avoid the entire problem of loading a file by pulling the data through a link. I have a script that will populate a table via a link and commit every so often so that you don't blow out on your rollback segments. If you wish to have it just email me.
Alternatively, if the extract is done by spooling SQL output to a disk you might investigate the use of the SQL*Plus "SET TRIMSPOOL" command.
Regards
Dale Edgar
Net 2000 Ltd.
DataBee - Oracle Database Subsets.
The simple and easy way to create small versions of large Oracle databases. http://www.databee.com
On 18 Sep 2001 08:58:07 -0700, KevinGurney_at_yahoo.co.uk (Kevin Gurney) wrote:
>Hi,
>
>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 - 18:37:37 CEST