Re: Export of very big table

Did you try the export/import written by Rachel Camichael? They create a file or files of 2 gig. They can be found on the LazyDBA website under scripts. I am using them to import as we speak.

HTH,
Ruth
----- Original Message -----
From: <eric.lansu_at_dutchtone.nl>
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Friday, December 22, 2000 6:30 AM
Subject: 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

> > 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).
Received on Tue Dec 26 2000 - 09:26:31 CST