Re: Error Analyzing SYS Schema in 8.0.3

From: Stephen Darlington <Stephen_Darlington>
Date: 1998/02/26
Message-ID: <6d3n8q$cr5@romeo.logica.co.uk>#1/1

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 rulerather  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 Thu Feb 26 1998 - 00:00:00 CST