Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Make table read-only
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.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace 'x' with 'u' to respond)Received on Wed Oct 20 2004 - 01:21:23 CDT
![]() |
![]() |