Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: how to exp big table with 2GB file size limitation?
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
![]() |
![]() |