Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Where is v$locked_object
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 Thu Oct 07 1999 - 10:14:14 CDT