Re: ALTER TABLE LOCK DISABLE
- From: Jared Still <jkstill@xxxxxxxxx>
- To: paul.baumgartel@xxxxxxxxx
- Date: Sat, 26 Mar 2005 18:50:08 -0800
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@xxxxxxxxx> 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@xxxxxxxxx> wrote:
> > > From: K Gopalakrishnan [mailto:kaygopal@xxxxxxxxx]
> > > I wouldn't subscribe to DISABLE TABLE LOCKS arguement as that posses a
> > > serious threat to HA operations.
> --
> //www.freelists.org/webpage/oracle-l
>
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
//www.freelists.org/webpage/oracle-l
Other related posts:
