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