RE: V$OBJECT_USAGE view for indexes in all schemas
- From: "Jesse, Rich" <Rich.Jesse@xxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 18 May 2004 12:15:12 -0500
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@xxxxxxxxxxxxxxxxx QuadTech, Sussex, WI USA
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> 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 and subsequent
> grants throw ORA-600 [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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
