Re: Export of very big table. Solution?

<plug>

   Oriole's pdqout
</plug>

Stephane Faroult
Oriole Corporation

>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_at_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_at_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).
>

--
This mail was sent through http://www.mail-inspector.de
Mail Inspector is a free service of http://www.is-fun.net CHECK OUT !

This mail was sent from host 195.25.229.12