Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: unlocking tables
On Wed, 13 Feb 2002 10:39:39 -0500, "Cameron Abbott"
<cvabbott_at_altavista.com> wrote:
>Hi,
>
>Does anyone know of an sql statement that will find a locked table and the
>sql statement causing the lock? Also, what is the command to unlock the
>table.
>
>Thanks
>Cameron
>
The commands to unlock a table are commit and rollback
Regards
Sybrand Bakker, Senior Oracle DBA
To reply remove -verwijderdit from my e-mail address Received on Wed Feb 13 2002 - 12:06:46 CST