Wednesday, July 13, 2011

Read only tables in 11g

Read only tables:
In oracle 11g we can set table to read only property. By this no other modifications will be done on that table.

Syntax: alter table read only;

Example: alter table employee read only;
By this we are going to set employee table to read only. So no modifications will be done on that table.