Is any size limit when using export?

When doing a conventional path export I get the error

EXP-00002: error in writing to export file

the moment the dmp file reaches 2GB.

Any ideas on how do I over come this 2GB limit ?

Ans1:
it seems that Your file size is limited on OS level.
I had a similar problem while sizing a database on an AIX system...
the size limit was also 2GB.

Ans2:
EXP-00002 error is due to device. I am not sure to where your exporting to
external disk or to the server itself. Plase check the OS limitations.

Ans3:
How about compressing dump file on the fly during export ?!

Check this out, it might help in beating 2GB barrier.

        -- create a named pipe
        $ mknod exp.pipe p
        -- read the pipe - output to compress in the background
        $ compress < exp.pipe > scott.exp.Z &
        -- you could use any compression utility.
        -- feed the pipe
        $ exp userid=scott/tiger file=exp.pipe ...

-R.K.Muthu

Hosted by www.Geocities.ws