Work out what session has a lock on the table and if necessary kill the
session by:

SQL> alter system kill session <SID>, <SERIAL#>;

Niels

-----Original Message-----
From: m [mailto:oracledba-ezmlmshield-x81621515.[Email address protected]

Sent: Thursday, 5 January 2006 4:11 PM
To: LazyDBA Discussion
Subject: Unlocking a Table.


Dear All,

Can anyone tell me how to unlock a table through SQL prompt?.

Suresh M

Notice: The information contained in this e-mail message and/or
attachments to it may contain confidential or privileged information.
If you are not the intended recipient, any dissemination, use, review,
distribution, printing or copying of the information contained in this
e-mail message and/or attachments to it are strictly prohibited. If
you have received this communication in error, please notify us by reply
e-mail or telephone and immediately and permanently delete the message
and any attachments. Thank you


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html



Oracle LazyDBA home page