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 and Data Dictionary views on Oracle 7.3.4.0.1

Re: Analyze and Data Dictionary views on Oracle 7.3.4.0.1

From: John D. H. Wilson <John_at_wlsc.mdn.com>
Date: Wed, 16 Sep 1998 17:48:25 -0500
Message-ID: <6tpfbb$p93$1@news.indy.net>


Oracle states that you should never run analyze on the system tablespace and the tables that comprise the Data Dictionary.

Roman Gelfand wrote in message <6t8m24$ns8$1_at_news.monmouth.com>...
>There are no error messages. However catalog tables and views get
>corrupted.
>
>
>Winnie Liu wrote in message <6t7jmt$t6h_at_sjx-ixn10.ix.netcom.com>...
>>Every time you analyze the tables or indexes... Oracle had to updated
>>certain dictionary views and tables. But what do you mean by the
dictionary
>>views get screwed up? What kind of error message do you get?
>>
>>Winnie
>>
>>Roman Gelfand wrote in message <6t6pgd$kd8$1_at_news.monmouth.com>...
>>>It seems like every time we run analyze on Oracle 7.3.4.0.1, the data
>>>dictionary views get screwed up. Is this really what is taking place?
Is
>>>there any way to solve it?
>>>
>>>
>>
>>
>
>
Received on Wed Sep 16 1998 - 17:48:25 CDT

Original text of this message

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