How to Make a Tablespace Read only in Oracle Database
Making a tablespace read-only prevents write operations on the datafiles in the tablespace. The primary purpose of read-only tablespaces is to eliminate the need to perform backup and recovery of large, static portions of a database. Read-only tablespaces also provide a way to protecting historical data so that users cannot modify it. Making a tablespace read-only prevents updates on all tables in the tablespace, regardless of a user's update privilege level.
To make a tablespace read only
SQL>alter tablespace ica read only;
Again to make it read write
SQL> alter tablespace ica read write;
No comments:
Post a Comment