一直以来总有人问，能够将Oracle数据库中的表设置成只读吗?在Oracle11g之前回答是，不能。HJR甚至写过一篇完整的文章来阐述这个问题。Oracle 11g终于带来了这个新特性，设置表为Readonly，简单的一个命令而已。
SQL> CREATE TABLE "KAMUS"."T1" ( "N" NUMBER);
Table created
Executed in 0.047 seconds
SQL> alter table t1 read only;
Table altered
Executed in 0.125 seconds
SQL> insert into t1 values(1);
insert into t1 values(1)
ORA-12081: update operation not allowed on table "KAMUS"."T1"
SQL> alter table t1 read write;
Table altered
Executed in 0.015 seconds
SQL> insert into t1 values(1);
1 row inserted
Executed in 0 seconds |
第
页
责任编辑:qwer19871212
