RE: How to find USER who locked my row ...

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Fri, 02 Feb 2001 11:26:11 -0800
Message-ID: <F001.002A95B9.20010202113014@fatcity.com>

> -----Original Message-----
> From: Janardhana Babu [mailto:jbdonga_at_ucdavis.edu]
> Sent: vendredi, 2. février 2001 11:00
>
> I tried to execute the query, It comes out with an error:
> dba_blockers does
> not exist. I verified in all of my Oracle 8i databases and
> have not found
> that view anywhere. Has it been removed in 8i? If not, I
> don't have any clue
> why it is not showing up?

The view will be created if you run
$ORACLE_HOME/rdbms/admin/catblock.sql

---

any ignorant comments made are the sole responsibility of J. R. Kilchoer and should not reflect adversely upon my employer.

 
Jacques R. Kilchoer
(949) 754-8816
Quest Software, Inc.
8001 Irvine Center Drive
Irvine, California 92618
U.S.A.
http://www.quest.com Received on Fri Feb 02 2001 - 13:26:11 CST