Re: Basic problem on export

If you are running on Unix you could compress your export online the basic idea is create a pipe with mknod start a compress session with &
export to the pipe.
There is a script of Thomas Kyte in the Deja archives, which will so this in detail and also at the same time creates multiple file smaller than 2G

Hth,

Sybrand Bakker, Oracle DBA

Laufrech <laufrech_at_aol.com> wrote in message news:19990627144239.06508.00004499_at_ng-fo1.aol.com...
> Hello,
>
> I have to use the exp command of Oracle 8.04 to extract some data from my
> database for backup purpose.
>
> But, I have a basic problem: limitation to 2 Go for a user. Is there any
better
> tool or I have to split my tables and then export them ? I could make an
ASCII
> spool but in some of my tables, I have blanks to keep and in some others,
> blanks not to keep. exp is a good method to skeep the analysis of all my
tables
> (a lot !!!).
>
> Thanks in advance.
>
> L. Aufrechter
Received on Sun Jun 27 1999 - 16:57:24 CDT