11g

Eine Tabelle kann unter Oracle 11g in den Read Only Modus gesetzt werden.

ALTER TABLE emp READ ONLY;
 
DELETE FROM emp
            *
FEHLER IN Zeile 1:
ORA-12081: Aktualisierenvorgang bei Tabelle "GPI"."EMP" nicht zulõssig
 
SELECT TABLE_NAME, READ_ONLY FROM  user_tables WHERE TABLE_NAME='EMP';
 
TABLE
Name               READ_ONLY
------------------ ---
EMP                YES

folgende Operationen sind aber noch zulässing:

• SELECT
• CREATE/ALTER/DROP INDEX
• ALTER TABLE ADD/MODIFY/DROP/ENABLE/DISABLE CONSTRAINT
• ALTER TABLE for physical property changes
• ALTER TABLE DROP UNUSED COLUMNS
• ALTER TABLE ADD/COALESCE/MERGE/MODIFY/MOVE/RENAME/SPLIT (SUB)PARTITION
• ALTER TABLE MOVE
• ALTER TABLE ENABLE ROW MOVEMENT and ALTER TABLE SHRINK
• RENAME TABLE and ALTER TABLE RENAME TO
• DROP TABLE
• ALTER TABLE DEALLOCATE UNUSED
• ALTER TABLE ADD/DROP SUPPLEMENTAL LOG

ALTER TABLE emp READ WRITE;
 
 
SELECT TABLE_NAME, READ_ONLY FROM  user_tables WHERE TABLE_NAME='EMP';
 
TABLE
Name               READ_ONLY
------------------ ---
EMP                NO

Oracle Doku

• Placing a Table in Read-Only Mode ⇒ http://docs.oracle.com/cd/B28359_01/server.111/b28310/tables006.htm#ADMIN12316

Blog:

• http://dwhlaureate.blogspot.in/2015/02/read-only-tables-in-oracle-11g.html