How do I export all tables except 3

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 - 16:57:10 CET