Re: Basic problem on export

From: Mark Malakanov <markmal_at_sprint.ca>
Date: Sun, 27 Jun 1999 21:12:45 -0300
Message-ID: <8Xzd3.165771$r_1.38552039@newscontent-02.sprint.ca>

You can export users or tables separately.

rem Full export of objects without data exp80 sys/passw FULL=Y ROWS=N
rem Separate export of data
exp80 sys/passw FILE=tabset1.dmp TABLES=(user1.table1, user1.table2...) exp80 sys/passw FILE=tabset2.dmp TABLES=(user1.table99, user2.table22...)

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 - 19:12:45 CDT