Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: dropping analyze objects from data dictionary
I had heard the same thing about 9i. And I also heard a rumor that in a
future version (10?) that analyzing SYS objects would be required. This
makes sense in the demise of RBO.
Cheers,
Brian
Norman Dunbar wrote:
>
> <Dons Nomex suit and prepares for a flame fest>
>
> I believe that you *can* safely analyze SYS objects under 9i (could be
> Release 2 only though !) without any ill effects.
>
> Not that I have done it.
>
> Nor will I be doing it - unltil I get advice from Oracle, but I have
> read (on Metalink) something that says 'it makes no difference' under
> 9i. Of couse, I cannot find the damned note when I'm looking for it, but
> when I do, I'll repost !
>
> Cheers,
> Norm.
>
> (Going home before the flames start !!!)
>
> -------------------------------------
> Norman Dunbar
> Database/Unix administrator
> Lynx Financial Systems Ltd.
> mailto:Norman.Dunbar_at_LFS.co.uk
> Tel: 0113 289 6265
> Fax: 0113 289 3146
> URL: http://www.Lynx-FS.com
> -------------------------------------
-- =================================================================== Brian Peasland dba_at_remove_spam.peasland.com Remove the "remove_spam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three"Received on Tue Jul 29 2003 - 12:26:36 CDT