在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
1200字范文,内容丰富有趣,写作的好帮手!