Friday, May 10, 2013

Read Only Tables In Oracle 11g

 In Oracle 11g, a table can be set READ ONLY mode to restrict write operations on the table. A table can be altered to toggle over READ ONLY and READ WRITE modes.


Example 1:
SQL> ALTER TABLE EMP READ ONLY;
Example 2: 
SQL> ALTER TABLE EMP READ WRITE;

No comments:

Post a Comment