Re: How to exclude few tables while gathering a schema stats in oracle 9i

  • From: "Jared Still" <jkstill@xxxxxxxxx>
  • To: p4cldba@xxxxxxxxx
  • Date: Mon, 24 Dec 2007 15:02:34 -0800

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@xxxxxxxxx> 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

Other related posts: