Re: Where is v$locked_object

That explains it!

Thanks

fumi <fumi_at_tpts5.seed.net.tw> wrote in message news:7tl7on$n28$5_at_news.seed.net.tw...
>
> Nick Rumble <rumbln_at_tetraworld.com> wrote in message
> news: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 ?
>
>
> v$locked_object is available since Oracle 7.3.
>
> The synonym and view are created using CATALOG.SQL.
>
>
>
Received on Sun Oct 10 1999 - 09:08:32 CDT