Re: Error Analyzing SYS Schema in 8.0.3

Never analyze the SYS schema in Oracle 7 or 8, most access to the dictionary in Oracle 8 either uses Rule or Hinted (thus forced Cost Plan).

Use the analyze_schema procedure if you must analyze SYS, because it avoids the dynamic tables such as FET$ and UET$ etc.

Regards
David

Stephen Darlington > wrote in message <6d3n8q$cr5_at_romeo.logica.co.uk>...
>Ed Jennings wrote in message <34F4D102.7A43_at_mindspring.com>...
>>I executed the following command from sqlplus while logged on as SYSTEM,
>>and was amazed that I had a privilege problem. I then reconnected as
>>SYS and received the identical error. Can anyone explain this? How can
>>SYS have a privilege problem with its own objects???
>
>
>Should you be analysing the SYS schema? Oracle 7 is designed to use rule-
>rather than cost-based optimisations for SYS. The procedure might be
>deliberately raising an exception to stop you doing something silly.
>
>However, I've never use Oracle 8 so I might be way off the mark...
>
>--> Steve
>---------------------------------------------------------------------------
 -
> Stephen Darlington (public.logica.com/~darlings/)
> "I blame sex and paper for most of our problems"
> Don't believe a single word I say -- these are my words, not Logica's
>---------------------------------------------------------------------------
 -
>
>
>
Received on Sat Feb 28 1998 - 00:00:00 CST