From rahul@ratelindo.co.id Wed, 03 Oct 2001 20:55:17 -0700 From: Rahul Date: Wed, 03 Oct 2001 20:55:17 -0700 Subject: RE: disable table lock ...cannot revert it In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: text/plain could be a bug... metalink suggests modifying DML_LOCKS = 0 and then doing the alter table t enable table lock; should work.... > ---------- > From: Vadim Gorbounov[SMTP:vgorbounov@simplyengineering.com] > Reply To: ORACLE-L@fatcity.com > Sent: Wednesday, October 03, 2001 9:50 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: disable table lock ...cannot revert it > > 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 AM > To: Multiple recipients of list ORACLE-L > > > 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 ????!!!!! > > same case for dropping the table... i cannot drop it either..??? > > TIA > Rahul > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rahul > INET: rahul@ratelindo.co.id > > 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@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). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Vadim Gorbounov > INET: vgorbounov@simplyengineering.com > > 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@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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: rahul@ratelindo.co.id 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@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).