On Tuesday 02 October 2001 21:31, Reardon, Bruce (CALBBAY) wrote: > > As for the locked table, what do you see in v$locked_object for the table > (eg what type of lock).
Lock type 'TM', lock mode 6 ( exclusive table lock ) It appears that disallowing table locks does not prevent all methods of locking a table, just those that would prevent any SRX ( share row exclusive ) locks for DML. Jared > > Regards, > Bruce Reardon > > -----Original Message----- > From: Jared Still [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, 3 October 2001 14:20 > > > Interesting, I didn't know about that. > > It won't however, unlock a table. > > What it will do is prevent DDL on the > table by disabling the use of exclusive > locks on the table. > > 20:17:08 jkstill@ts01 SQL> alter table x modify ( x not null ); > alter table x modify ( x not null ) > * > ERROR at line 1: > ORA-00069: cannot acquire lock -- table locks disabled for X > > The Fine Documentation erroneously states that it > will prevent DML, which it does not. > > Jared > > On Tuesday 02 October 2001 03:20, ASHRAF SALAYMEH wrote: > > Try this: > > Alter table table_name disable table lock; > > > > --- Ha Duy Thien <[EMAIL PROTECTED]> wrote: > > > Hi all > > > > > > Does anyone know how to unlock a locked table? > > > > > > > > > Thanks in advance > > > > > > Ha Duy Thien -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).