Re: How do I export all tables except 3

"exp" has a parameter called "PARFILE". Put all your parameters in an external file, then use:

exp PARFILE=filename.ext

T'should work fine.

JP

bpeasey_at_doncarsys.com (Brian Peasey) wrote in message news:<f044b9cc.0203220757.da1bf42_at_posting.google.com>...
> Hi,
>
> I have been trying to export all the tables in our schema except the 3
> largest,
> but without success on the script below:
>
> host exp nat/nat_at_rates file=test.dmp tables=( ACTIVITY, ADD_FEES,
> ASSOCDIR, BAD_LINE_ORDER,....190 more)
>
> When the line wraps in sqlplus it fails. If I limit the list so there
> is no
> wrap then it runs.
>
> This schema has 4 tablespaces. Perhaps there is a way to only export 2
> of the for tablespaces?
>
> Any suggestion or alternatives?
>
> Thanks,
> Brian
Received on Fri Mar 22 2002 - 19:53:27 CET