disable table lock ...cannot revert it

2001-10-03 Thread Rahul
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

RE: disable table lock ...cannot revert it

2001-10-03 Thread Vadim Gorbounov
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