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

Let’s create a table and make it read-only.

Any DML statements that affect the table data results in an ORA-12081 error message.

DML and DDL operations return to normal once the table is switched back to read-write mode.

The read-only status of tables is displayed in the READ_ONLY column of the [DBA|ALL|USER]_TABLES views.

Comments

Leave a Reply