Re: Make table read-only

Nothing to feel embarassed. It's easy to miss it particularly when it's not emphasised in the "new features". I first noticed in 8i under "alter table " syntax (in SQL reference), though per Mark Stock it was available in 7.x. I found it very interesting but never had to use it, till date.

I usually make it a point (when time permits!) to scan thru the entire Sql reference manual every time a new version comes in , so as not to miss "hidden" features.

-Madhu S

DA Morgan <damorgan_at_x.washington.edu> wrote in message news:<1098253232.730656_at_yasure>...
> MS wrote:
>
> > In addition to the trigger to disable DML, disabling table lock does
> > the trick.
> >
> > So, for the mentioned example:
> >
> > SQL> alter table t disable table lock;
> >
> > This prevents sqlldr direct load, as well as truncate, and DDL's on
> > this table (including drop table).
> >
> >
> > -Madhu S
>
> Fascinating. Where did you find this documented?
>
> And yes I expect your answer to embarass me so go ahead.
Received on Wed Oct 20 2004 - 14:51:42 CDT