Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Export of very big table

Re: Export of very big table

From: jared still <>
Date: Fri, 22 Dec 2000 09:28:38 -0800 (PST)
Message-Id: <>


Why doesn't splitting the files work for you?

Do you receive errors or what? It should work fine, many of us have done this.


On Fri, 22 Dec 2000 wrote:

> 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
> DutchTone - IS (Cap Gemini)
> It's time for the 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
> > receipt.
> >
> >
> --
> Please see the official ORACLE-L FAQ:
> --
> Author:
> 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: (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).

Jared Still
Certified Oracle DBA and Part Time Perl Evangelist ;) Received on Fri Dec 22 2000 - 11:28:38 CST

Original text of this message