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

From: Russ Eberle <russ.eberle_at_born.com>
Date: 1996/12/17
Message-ID: <594uqr$eek@news.mr.net>#1/1

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.com Received on Tue Dec 17 1996 - 00:00:00 CST