RE: please help me to unlock a table

The table lock is also discussed a bit on Ixora, including Steve's suggestion that (in some cases) instead of foreign key indexes you may want to consider disabling table locks instead.

See page 53 of his book for his discussion of this.

As for the locked table, what do you see in v$locked_object for the table (eg what type of lock).

Regards,
Bruce Reardon

-----Original Message-----
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_at_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 <thienhd_at_yahoo.com> 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: Reardon, Bruce (CALBBAY)
  INET: Bruce.Reardon_at_comalco.riotinto.com.au

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: ListGuru_at_fatcity.com (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).