Oracle Database 11g: Read only tables

Read-Only Tables in Oracle Database 11g

Oracle 11g allows tables to be marked as read-only using the ALTER TABLE command.

ALTER TABLE table_name READ ONLY;
ALTER TABLE table_name READ WRITE;


Any DML statements that affect the table data and SELECT ... FOR UPDATE queries result in an ORA-12081 error message.

No comments:

Post a Comment