Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: How to exclude few tables while gathering a schema stats in oracle 9i

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

From: Jared Still <jkstill_at_gmail.com>
Date: Thu, 27 Dec 2007 06:43:28 -0800
Message-ID: <bf46380712270643jd7be5d3g2bec0a2f9d1316ef@mail.gmail.com>


Hmm, not sure what I was thinking when I wrote this.

Sorry for the slight misinformation, it appears I was thinking of 'exp' for some reason.

Jared

On Dec 24, 2007 3:02 PM, Jared Still <jkstill_at_gmail.com> wrote:

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

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Dec 27 2007 - 08:43:28 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US