Oracle只读表能阻止表上所有的DML操作(truncate/insert/update/delete)
sql> create table t_zhasir as select * from dba_objects where rownum < 10;
--设置表为只读
sql> alter table t_zhasir read only;
Table altered.
--设置表为读写状态
sql> alter table t_zhasir read write; Table altered.