Re: ALTER TABLE LOCK DISABLE

Locking down DDL would wreak havoc on some systems, so you would have to be pretty careful about doing so.

SAP for instance has it's own mechanisms for moving DDL through the developement lifecycle, and locking down DDL would break it.

Those of you in an SAP environment know it is rarely static.

Jared

On Fri, 25 Mar 2005 17:07:47 -0500, Paul Baumgartel <paul.baumgartel_at_gmail.com> wrote:
> 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
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l