Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Error Analyzing SYS Schema in 8.0.3
Hi
I don't know it for Version 8.x but in version 7.x you shoudn't have analyzed the sys/system schemas, cause oracle uses the rule based optimizer for the data dictionary. So i woud recommend don't do it.
rgds
eugen
Falk Schiel wrote:
>
> Connect as system and try using
>
> execute dbms_utility.analyze_database('ESTIMATE');
>
> Falk
Received on Fri Feb 27 1998 - 00:00:00 CST