Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Error Analyzing SYS Schema in 8.0.3
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???
TIA Ed
SQL> exec dbms_utility.analyze_schema('SYS', 'ESTIMATE')
*
ERROR at line 1:
ORA-20000: You have insufficient privileges for an object in this
schema.
ORA-06512: at "SYS.DBMS_UTILITY", line 256
ORA-06512: at line 1
SQL>
-- ~~~~~~~~~~~~~~~~~~~~~~~~~ jenningse_at_mindspring.com "The opinions expressed here are my own, not those of DOMAIN technologies"Received on Wed Feb 25 1998 - 00:00:00 CST