Shulou(Shulou.com)06/01 Report--

One of the new features of Oracle 11g-read-only meter (read only table)

Oracle11g has introduced a new feature that allows table to be placed in the read only state, where table cannot perform DML operations and some DDL operations. In previous versions of Oracle11g, only the entire tablespace or database could be placed in the read only state. The control of table can only be set by permissions.

Case study:

11:44:46 SCOTT@ test1 > select * from tab TNAME TABTYPE CLUSTERID---BONUS TABLECREDIT_CLUSTER CLUSTERCREDIT_ORDERS TABLE 1DEPT TABLEEMP TABLEEMP1 TABLE11:44:56 SCOTT@ test1 > select count (*) from emp1 COUNT (*)-18Elapsed: 00 COUNT 0012 SCOTT@ test1 > alter table emp1 read only;Table altered.11:51:46 SCOTT@ test1 > select read_only from user_tables where table_name='EMP1';REA---YES do DML:11:45:20 SCOTT@ test1 > insert into emp1 select * from emp where rownum=1 for read-only table Insert into emp1 select * from emp where rownum=1 * ERROR at line 1:ORA-12081: update operation not allowed on table "SCOTT". "EMP1" Elapsed: 00 SCOTT@ test1 0011 00.0411 update operation not allowed on table 45 SCOTT@ test1 38 SCOTT@ test1 > delete from emp1;delete from emp1 * ERROR at line 1:ORA-12081: update operation not allowed on table "SCOTT". Update emp1 set sal=6000 where empno=7788 * ERROR at line 1:ORA-12081: update operation not allowed on table "SCOTT". "EMP1" TRUNCATE TABLE:11:46:03 SCOTT@ test1 > truncate table emp1;truncate table emp1 * ERROR at line 1:ORA-12081: update operation not allowed on table "SCOTT". "EMP1" Elapsed: 00:00:00.09DROP TABLE:11:46:45 SCOTT@ test1 > drop table emp1;Table dropped.Elapsed: 00 Elapsed 00.7011 SCOTT@ test1 > show recycle ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIME- EMP1 BIN$ComP5WftmQ7gUKjA+QgIyQ==$0 TABLE 2014-12-19 Distillery 11VOUL 47UR 0411: 47:52 SCOTT@ test1 > flashback table emp1 to before drop Flashback complete.11:49:56 SCOTT@ test1 > select count (*) from emp1; COUNT (*)-18 MOVE TABLE: 11:50:06 SCOTT@ test1 > alter table emp1 move;Table altered.Elapsed: 0000MOVE TABLE 00.54 Compression Table: 11:51:27 SCOTT@ test1 > alter table emp1 compress;Table altered.Elapsed: 0000VOOOOOOOO911 PLV 51RH 39 SCOTT@ test1 > alter table emp1 nocompress Table altered.Elapsed: 00.16 constraint management: 11:52:53 SCOTT@ test1 > alter table emp1 add constraint fk_emp1 foreign key (deptno) references dept (deptno); Table altered.11:54:29 SCOTT@ test1 > alter table emp1 drop constraint fk_emp1;Table altered.11:54:47 SCOTT@ test1 > create index emp1_empno_ind on emp1 (empno) tablespace indx;Index created. Index management: 11:55:17 SCOTT@ test1 > drop index emp1_empno_ind;Index dropped. Configure read write:11:55:27 SCOTT@ test1 > alter table emp1 read write;Table altered.11:55:37 SCOTT@ test1 > select read_only from user_tables where table_name='EMP1';REA---NO

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.