Re: Where is v$locked_object

Ahh thanks - I've now found this in 8.0.5 but it's not in 7.2.3. But what's more of a worry
is that 7.2.3 doesn't contain the v_$locked_object view.

How is this built ?

Regards

Nick

Michel Cadot <micadot_at_netcourrier.com> wrote in message news:7tiddk$g5m$1_at_oceanite.cybercable.fr...
> I use 7.3.4 and 8.0.5 and in both of it i found the definition
> of v$locked_object in catalog.sql in the rdbms/admin directory.
>
> as sys run:
> create or replace view v_$locked_object as select * from v$locked_object;
> drop public synonym v$locked_object;
> create public synonym v$locked_object for v_$locked_object;
> grant select on v_$locked_object to select_catalog_role; -- for 8.0.5
>
>
> --
> Regards
>
> Michel
>
>
> Nick Rumble <rumbln_at_tetraworld.com> a écrit dans le message :
> 939307149.27223.0.nnrp-09.c2d9cf02_at_news.demon.co.uk...
> > Hi
> >
> > I'm using Toad to trace locked objects within Oracle and it seems to
rely on
> > a view called v$locked_object.
> >
> > Problem is - I can't find this view within my 7.2.3 or 8.0.5 database -
nor
> > is it defined in any of the .sql files shipped with these releases.
> >
> > Does anyone know where I can find it ?
> >
> > Thanks
> >
> > Nick
> >
> >
>
>
Received on Fri Oct 08 1999 - 04:31:38 CDT