RE: Export of very big table. Solution?

I have been able to use PRO*C programs to export tables to fixed-width files pretty quicky. On a pretty-darn-quick Sun box, I was getting "export" rates of about 10k-25k records per second. 10k/sec would export 22m in about 40 minutes.

The PRO*C program was doing bulk-binds.

If you have 8.1.6 you have the option of doing direct exports if noone is performing updates on the table.

Kevin

> -----Original Message-----
> From: eric.lansu_at_dutchtone.nl [mailto:eric.lansu_at_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_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).
Received on Tue Jan 09 2001 - 08:56:06 CST