Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Analyze and Data Dictionary views on Oracle 7.3.4.0.1
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