RE: Please tell me how to know whether or not a table is locked

From: Natalia Laracca <nlaracca_at_afip.gov.ar>
Date: Thu, 06 Sep 2001 06:55:18 -0700
Message-ID: <F001.003852AC.20010906070113@fatcity.com>

Hi,
select dbo.owner||'.'||dbo.object_name
object,
<FONT
face=Arial>
dbo.Object_type
from v$locked_object lo,

dba_objects dbo
where lo.object_id = dbo.object_id
/

<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">

Original Message ----- <DIV style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: Ha Duy Thien

  To: <A href="mailto:ORACLE-L_at_fatcity.com"   title=ORACLE-L_at_fatcity.com>Multiple recipients of list ORACLE-L   Sent: Thursday, September 06, 2001 5:00   AM
  Subject: Please tell me how to know
  whether or not a table is locked

  Hi Gurus

  Please let me know which view can show me a table   that is being locked.

  Thanks a
lot Received on Thu Sep 06 2001 - 08:55:18 CDT