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