Re: Exporting large (>8 gig) database in UNIX?

Russ Eberle wrote:
>
> squinn_at_netcomuk.co.uk (Simon Quinn) wrote:
>
> >What is the best way to do a full export on an ORACLE database on
> >UNIX?
 
> >The current file size limit on the version we are using is 2Gigabytes
> >and I estimate the database will be 8 Gig in size.
 

> >What is the best way to split it into separate sections or is there an
> >option in EXP to split the export file? I am using v7.2.3.
 

> >Thanks
> >Simon.
>
> I've writen shell scripts to query the DB by tablespace and export all
> tables within a tables space. It cuts doen some of the size but only
> does tables.
>
> You could also use a named pipe and exp to it compressing on the fly.
> This reduces the size significantly, but probably not 8 GB.
>
> Just a few thoughts.
>
> Russ russ.eberle_at_born.comDo full exp first with rows=n then by TS...
Received on Wed Dec 18 1996 - 00:00:00 CST