Read-Only Table

Read-Only Table

Prior to Oracle Database 11g, there was a facility to place an entire tablespace in Read-Only mode but none for single table. Either you place the table in that tablespace or write trigger on table that would raises an exception to prevent data being modify in the events of DML operations. Oracle Database 11g allows … Continue reading →