Thanks, Boris! Your bug is so new the Support analyst didn 't find it =
until I redirected him to it (save the comments -- I 'm giving him the =
benefit of the doubt). For now, I 've created a "QT_INDEX_USAGE " view in =
SYS that incorporates all schemas, unlike the Oracle-supplied =
V$OBJECT_USAGE fixed view. I 'm not terribly comfortable with the idea =
of creating user objects in SYS for a production system, but at least =
the recommendation for it is in the TAR as well as another MetaLink =
article, so my CYA is in place.
Working a TAR with the help of this list makes a big difference! :)
Thanks again!
Rich
Rich Jesse System/Database Administrator
rich.jesse@(protected) QuadTech, Sussex, WI USA
> -- --Original Message-- --
> From: oracle-l-bounce@(protected)
> Sent: Tuesday, May 18, 2004 7:50 AM
> Subject: Re: V$OBJECT_USAGE view for indexes in all schemas
>=20
>=20
> Worked just fine for us before 9.2.0.5
>=20
> In 9.2.0.5 "grant select on sys.object_usage to ... "
> for the first time raises ORA-701 (See ORA-701.ora-code.com) and subsequent
> grants throw ORA-600 (See ORA-600.ora-code.com) [17058]
>=20
> Support opened bug 3627650 for us, which apparently
> (as in not confirmed yet) can be fixed with the
> one-off patch for bug 2934068
>=20
> Thanks,
> Boris Dali.
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
