Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: ALTER TABLE LOCK DISABLE

Re: ALTER TABLE LOCK DISABLE

From: Paul Baumgartel <paul.baumgartel_at_gmail.com>
Date: Fri, 25 Mar 2005 17:07:47 -0500
Message-ID: <f8c4771050325140759ec1ba9@mail.gmail.com>


There is another way to prevent dropping tables: DDL triggers, which can trap DROP (or other DDL operations) either database-wide or in a particular schema, and prevent their completion.

On Fri, 25 Mar 2005 15:14:14 -0600, jungwolf <spatenau_at_gmail.com> wrote:
> > From: K Gopalakrishnan [mailto:kaygopal_at_gmail.com]
> > I wouldn't subscribe to DISABLE TABLE LOCKS arguement as that posses a
> > serious threat to HA operations.

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Mar 25 2005 - 17:11:33 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US