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: Mon, 24 Dec 2007 15:02:34 -0800
Message-ID: <bf46380712241502g4a6424d6mc538533ea8bf26db@mail.gmail.com>


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-l
Received on Mon Dec 24 2007 - 17:02:34 CST

Original text of this message

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