Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Exporting large (>8 gig) database in UNIX?

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

From: Jim Mahoney <jimntina_at_mindspring.com>
Date: 1997/01/12
Message-ID: <32d872b6.8131270@news.mindspring.com>#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 don't think there are any options to break up an export into 2gig files. The only thing I can think of would be to export by table, user or schema. This assumes there are no 2gig + objects.

Jim Received on Sun Jan 12 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US