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

Hi Simon,

i do a 10GB database backup using the 'export to pipe and compress on the fly' method using gzip. See FAQ or mail me if you need syntax. Your resulting file must be < 2GB.

Onother way is to backup to tape using something like /dev/rmt0 (AIX) as file-name. EXP asks for tape-capacity and will prompt for new tape.

Kind regards,

Toni
In article <32b552bd.8498036_at_news.netcomuk.co.uk>, 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.
 

-- 
A. Dischner, SGI&AIX sysadmin, Oracle DBA       | Don't let friends
Institut fuer Klinische Chemie                  | use WinDose
Klinikum Grosshadern                            | Just say NO. 
Ludwig Maximilians Universitaet Muenchen,  GER  |            
Marchioninistr.15 81366 Muenchen 49-89-70953202 |