Showing posts with label Oracle 11g. Show all posts
Showing posts with label Oracle 11g. Show all posts

Thursday, September 30, 2010

Placing a Table in Read-Only Mode in Oracle 11g

New in Oracle 11g, you can place a table in read-only mode with the ALTER TABLE...READ ONLY statement, and return it to read/write mode with the ALTER TABLE...READ WRITE statement. An example of a table for which read-only mode makes sense is a configuration table. If your application contains configuration tables that are not modified after installation and that must not be modified by users, your application installation scripts can place these tables in read-only mode. The table is in read-only mode, operations that attempt to modify table data are disallowed.