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

Home -> Community -> Usenet -> c.d.o.server -> Re: analyze table question

Re: analyze table question

From: Daniel A. Morgan <damorgan_at_exesolutions.com>
Date: Fri, 18 Jan 2002 21:13:41 +0000
Message-ID: <3C489005.DD0CAD03@exesolutions.com>


It is something that Oracle warns in its documentation, over and over and over and over, NOT TO DO!

Never analyze any object that is part of the data dictionary.

And RTFM!

Daniel Morgan

a wrote:

> I am developping a script to analyze table. Should we also include tables
> belonging to SYS? Or it is not necessary? How about index rebuild? Should
> we also including all the index belonging to SYS as well?
>
> Thanks for your help.
Received on Fri Jan 18 2002 - 15:13:41 CST

Original text of this message

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