Read only Table - Revision history

Ittichai at 00:10, 15 March 2011

2011-03-15T00:10:31Z

Ittichai at 00:10, 15 March 2011

2011-03-15T00:10:12Z

Ittichai: Created page with "A table can be set READ ONLY mode to restrict write operations. * Enable table for READ-ONLY

 SQL> alter table EMP read only;  Table altered

* The READ_ONLY column ..."

2011-03-15T00:09:22Z

Created page with "A table can be set READ ONLY mode to restrict write operations. * Enable table for READ-ONLY <pre> SQL> alter table EMP read only; Table altered </pre> * The READ_ONLY column ..."

New page

A table can be set READ ONLY mode to restrict write operations.

* Enable table for READ-ONLY
<pre>
SQL> alter table EMP read only;
Table altered
</pre>

* The READ_ONLY column of the user_tables confirms the change.
<pre>
SQL> select table_name, read_only from user_tables where table_name='EMP';

TABLE_NAME READ_ONLY
------------------------------ ---------
EMP YES
</pre>

* Making an attempt to do DML will fail.
<pre>
SQL> update EMP set SAL=2000 where ENAME='SMITH';

update EMP set SAL=2000 where ENAME='SMITH'

ORA-12081: update operation not allowed on table "AUDIT_USER"."EMP"
</pre>

* Enable table for READ-WRITE
<pre>
SQL> alter table EMP read write;

Table altered
</pre>
SQL> select table_name, read_only from user_tables where table_name='EMP';

TABLE_NAME READ_ONLY
------------------------------ ---------
EMP NO

[[Category:Database_Features]]

@@ Line 22: / Line 22: @@
 update EMP set SAL=2000 where ENAME='SMITH'
-ORA-12081: update operation not allowed on table "AUDIT_USER"."EMP"
+ORA-12081: update operation not allowed on table "USER1"."EMP"
 </pre>

@@ Line 30: / Line 30: @@
 Table altered
-</pre>
 SQL> select table_name, read_only from user_tables where table_name='EMP';
@@ Line 36: / Line 36: @@
 ------------------------------ ---------
 EMP                            NO
+</pre>
 [[Category:Database_Features]]