Xref: alice comp.databases.oracle.server:69211
Path: alice!news-feed.fnsi.net!newspump.monmouth.com!newspeer.monmouth.com!colt.net!dispose.news.demon.net!demon!news.demon.co.uk!demon![194.217.207.2]!not-for-mail
From: "Nick Rumble" <rumbln@tetraworld.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Where is v$locked_object
Date: Sun, 10 Oct 1999 15:08:32 +0100
Message-ID: <939564636.2880.0.nnrp-09.c2d9cf02@news.demon.co.uk>
References: <939307149.27223.0.nnrp-09.c2d9cf02@news.demon.co.uk> <7tl7on$n28$5@news.seed.net.tw>
X-Trace: news.demon.co.uk 939564636 nnrp-09:2880 NO-IDENT [194.217.207.2]:194.217.207.2
X-Complaints-To: abuse@demon.net
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Lines: 32

That explains it!

Thanks


fumi <fumi@tpts5.seed.net.tw> wrote in message
news:7tl7on$n28$5@news.seed.net.tw...
>
> Nick Rumble <rumbln@tetraworld.com> wrote in message
> news:939307149.27223.0.nnrp-09.c2d9cf02@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.
>
>
>