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: how to exp big table with 2GB file size limitation?

Re: how to exp big table with 2GB file size limitation?

From: Alexander Penev <webmaster_at_cska.net>
Date: Sat, 16 Sep 2000 10:48:35 GMT
Message-ID: <39C35006.35187A2B@cska.net>

Another solution:
You can export only the data structure, and then export only subsets of tables in such a way , that each export is smaller than 2 G. If you want to recover the database you can create first the tables, disable the constrains and import the small table exports one by one (IGNORE=Y) HTH John Matzen wrote:

> I'm running Oracle 8i on Solaris 2.7. How can I backup my 10GB of data with
> exp if I have a 2GB file size limitation?
>
> Thanks!
>
> John
Received on Sat Sep 16 2000 - 05:48:35 CDT

Original text of this message

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