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

[Natalia Laracca]

Hi, select dbo.owner||'.'||dbo.object_name object,             dbo.Object_type from v$locked_object lo,          dba_objects  dbo where lo.object_id = dbo.object_id /     ----- Original Message ----- From: Ha Duy Thien To: 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