Re: Export of very big table

Eric,

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.

Jared

On Fri, 22 Dec 2000 eric.lansu_at_dutchtone.nl 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
> 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
> > receipt.
> >
> >
> --
> 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).
>

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