Message-Id: <10736.126139@fatcity.com> From: "Mohan, Ross" Date: Tue, 9 Jan 2001 10:10:48 -0500 Subject: RE: Export of very big table. Solution? This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C07A4E.5939C590 Content-Type: text/plain; charset="iso-8859-1" what did you set the BS parameter to on the dd command? I have found increasing benefits up to about 128K, then it hits a knee and improvement is essentially flat. The default ( probably 2/4 K ) is too small. hth -----Original Message----- From: eric.lansu@dutchtone.nl [mailto:eric.lansu@dutchtone.nl] Sent: Tuesday, January 09, 2001 7:21 AM To: Multiple recipients of list ORACLE-L Subject: Export of very big table. Solution? Hello Listers, Some time ago I asked you how to export a very big file. The solution was in piping and UNIX-split. We did this before, but what we didn't do was dd-ing from the pipe to the dump file. We piped it straight in. It looks like this solved our corruption problem on compressed exports files. The problem remains it's very slow. Our exports may be in order now, but there's no way we can use them anymore. Next thing we are investigating is 'select'-ing it to a comma-delimited file, and restore it with SQL*Loader. A regular select is very slow though! It takes 2 1/2 days to unload the tabel (22.500.000 records) Does anyone know a faster way to create a flat-file of a table this size? Eric Lansu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: eric.lansu@dutchtone.nl Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ------_=_NextPart_001_01C07A4E.5939C590 Content-Type: text/html; charset="iso-8859-1" RE: Export of very big table. Solution?

what did you set the BS parameter to on the dd command?

I have found increasing benefits up to about 128K, then
it hits a knee and improvement is essentially flat.

The default ( probably 2/4 K ) is too small.

hth

-----Original Message-----
From: eric.lansu@dutchtone.nl [mailto:eric.lansu@dutchtone.nl]
Sent: Tuesday, January 09, 2001 7:21 AM
To: Multiple recipients of list ORACLE-L
Subject: Export of very big table. Solution?


Hello Listers,

Some time ago I asked you how to export a very big file. The solution was in
piping and UNIX-split.
We did this before, but what we didn't do was dd-ing from the pipe to the
dump file. We piped it straight in. It looks like this solved our corruption
problem on compressed exports files.

The problem remains it's very slow. Our exports may be in order now, but
there's no way we can use them anymore. Next thing we are investigating is
'select'-ing it to a comma-delimited file, and restore it with SQL*Loader. A
regular select is very slow though! It takes 2 1/2 days to unload the tabel
(22.500.000 records)

Does anyone know a faster way to create a flat-file of a table this size?

Eric Lansu
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: eric.lansu@dutchtone.nl

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).