Export of very big table

Hi listers,

I've been off the list for some time, but I'm back with a nice problem! Hope to resume helping you with your's too.

I have a database with tables of 10Gb. Creating the export-file fails, for Oracle has a problem creating a export-file with a compressed size of 1.5 Gb and more.
Oracle suggested to use a named pipe with the unix-split command, but this doesn't work either. We can use the method with the named pipe for an export-file with an uncompressed file size of 2Gb up to compressed 1.5Gb, but splitting it doesn't work.
It's an Oracle 7 database, so we cannot use the 8 functionality of exp to split the dump over more datafiles :-(

Help is very much appreciated, I will be in for 2.5 hours today, and then Wednesday again.

Prettige Kerst en een Gelukkig Nieuwjaar Merry Christmas and a Happy New Year

Eric Lansu, BEST-IT
ORACLE DBA
DutchTone - IS (Cap Gemini)

It's time for the www.best.nl in you

> The information contained in this communication is confidential and may be
> legally privileged. It is intended solely for the use of the individual or
> entity to whom it is addressed and others authorised to receive it. If you
> are not the intended recipient you are hereby notified that any
> disclosure, copying, distribution or taking any action in reliance on the
> contents of this information is strictly prohibited and may be unlawful.
> Dutchtone is neither liable for the proper and complete transmission of
> the information contained in this communication nor for any delay in its
Received on Fri Dec 22 2000 - 05:29:33 CST