Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> dropping analyze objects from data dictionary
<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 !!!)
Tel: 0113 289 6265 Fax: 0113 289 3146 URL: http://www.Lynx-FS.comReceived on Tue Jul 29 2003 - 11:44:55 CDT
-------------------------------------