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.
Showing posts with label 11g: New Features Read only tables. Show all posts
Showing posts with label 11g: New Features Read only tables. Show all posts
Subscribe to:
Posts (Atom)