Re: SQL Loader.

Another possibillity: Suppose you are trying to copy from the Oracle Financial database to another database and your client (SQL*Plus eg) has access to both databases, then you can use the 'COPY' command.

Copy will explain itself

hth

Marc

"Kevin Gurney" <KevinGurney_at_yahoo.co.uk> wrote in message news:aee40309.0109180758.67c2a42_at_posting.google.com...
> 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 Thu Sep 20 2001 - 14:46:47 CEST