Re: How do I export all tables except 3
From: justme <someq_at_rogers.com>
Date: Fri, 22 Mar 2002 16:40:52 GMT
Message-ID: <o8Jm8.1744$8K.1448_at_news02.bloor.is.net.cable.rogers.com>
Date: Fri, 22 Mar 2002 16:40:52 GMT
Message-ID: <o8Jm8.1744$8K.1448_at_news02.bloor.is.net.cable.rogers.com>
look at parfile
exp user/pass parfile=myfile
"Brian Peasey" <bpeasey_at_doncarsys.com> 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 - 17:40:52 CET