Oracle中的表如何设置成只读?
在Oracle11g之前回答是,不能。HJR甚至写过一篇完整的文章来阐述这个问题。Oracle11g终于带来了这个新特性,设置表为Readonly,简单的一个命令而已。 SQLCREATETABLE"KAMUS"."T1"("N"NUMBER); Tablecreated Executedin0.047seconds SQLaltertablet1readonly; Tablealtered Executedin0.125seconds SQLinsertintot1values(1); insertintot1values(1) ORA-12081:updateoperationnotallowedontable"KAMUS"."T1" SQLaltertablet1readwrite; Tablealtered Executedin0.015seconds SQLinsertintot1values(1); 1rowinserted