Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: How to exclude few tables while gathering a schema stats in oracle 9i
This can be done by only including the tables you need to export,
using the 'tables=' parameter of exp.
There is no provision for excluding tables, only for including.
On 12/24/07, Prasad <p4cldba_at_gmail.com> wrote:
>
> All,
>
> I need to do a stats generation for a oracle 9i db schema everynight.
> but there are few very large tables which I want to exclude while
> gathering the schema stats.
>
> Can someone please direct me how i can achieve this in Oracle 9i .
>
> Thanks
> _Prasad
>
-- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- http://www.freelists.org/webpage/oracle-lReceived on Mon Dec 24 2007 - 17:02:34 CST
![]() |
![]() |