I suspect the are some dictionary objects you do not have the correct privs
on, But UNDER NO CIRCUMSTANCES use analyze_database, it generates stat on
dictionary table and WILL cause performance degradation, I have seen so many
systems come to halt after running this. I would recommend analyze_schema.
Regards
David Russell
rlkeller_at_my-dejanews.com wrote in message
<6ngd3k$29l$1_at_nnrp1.dejanews.com>...
>
>
>Has anyone seen this. I am loged in as System and I get this error.
>
>Robert
>
>Oracle8 >exec dbms_utility.analyze_database('COMPUTE');
>begin dbms_utility.analyze_database('COMPUTE'); end;
>
>*
>ERROR at line 1:
>ORA-20000: You have insufficient privileges for an object in this database.
>ORA-06512: at "SYS.DBMS_UTILITY", line 281
>ORA-06512: at line 1
>
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Sun Jul 05 1998 - 13:55:21 CDT
