Oracle Support has reproduced the error in 9.2.0.5 on other platforms: GRANT SELECT ON sys.object_usage TO my_dba; ORA-00701: object necessary for warmstarting database cannot be altered After that, ORA-600s galore. Joy. I think we need to look at removing the 9.2.0.5 patch... Rich Rich Jesse System/Database Administrator rich.jesse@xxxxxxxxxxxxxxxxx QuadTech, Sussex, WI USA > -----Original Message----- > From: oracle-l-bounce@xxxxxxxxxxxxx > [mailto:oracle-l-bounce@xxxxxxxxxxxxx] > Sent: Monday, May 17, 2004 7:09 PM > To: oracle-l@xxxxxxxxxxxxx > Subject: RE: V$OBJECT_USAGE view for indexes in all schemas >=20 >=20 > What do you mean by "SYS.OBJECT_USAGE table cannot be changed, > apparently including GRANTs." > Are you signing on as SYSDBA and issuing the command > "GRANT SELECT ON OBJECT_USAGE TO MYUSER;" ? (you could also=20 > grant MYUSER > the system privilege SELECT ANY DICTIONARY) > That privilege should allow you to create your own copy of > V$OBJECT_USAGE in schema MYUSER. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------