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

mknod -p compress_pipe (lookup syntax in man pages to be sure on this)

Have the export write to compress_pipe and then do this: (again review syntax in man pages for correctness)

compress < compress_pipe > expfile.exp.Z

This will compress the export file on the fly. Most export files will compres way down. We routinely take a 24 gig database and compressed it is a 1.6 gb file.

Alternately you can replace compress_pipe with split_pipe and have the file split at the 2g mark into another file. I couldn't help you with the syntax for this one without seeing the script I have that does it. Do a man on mknod and that should help.

--
Dave A


"Alexander Penev" <webmaster_at_cska.net> wrote in message
news:39C35006.35187A2B_at_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

>