List,
a while ago someone on this list suggested a DDL which was new to me
so i tried it ..
SQL alter table t disable table lock;
the problem is ...i'm not able to alter it back to enable table lock !!!
as it requires a lock to do it and cannot lock it because i
disabled it already
Rahul,
Right, you can't drop or modify table after
alter table t disable table lock;
but
alter table t enable table lock;
still should work. Otherwise it could be a bug specific to you system.
HTH
Vadim Gorbounov
Oracle DBA
-Original Message-
Sent: Wednesday, October 03, 2001 7:05