Re: Make table read-only

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 Received on Tue Oct 19 2004 - 15:35:48 CDT