A read only tablespace prevents write operation to that tablespace. To view historical data
or to make report only we can make a tablespace read only. Read only tablespace also increase database performance as well.
The following statement makes the test tablespace read-only:
ALTER TABLESPACE test READ ONLY;
Again the following statement makes the test tablespace writable:
ALTER TABLESPACE test READ WRITE;
Note: Making a read-only tablespace writable updates the control file entry for the datafiles, so that you can use the read-only version of the datafiles as a starting point for recovery.
Note: In Data warehouse database read only tablespace is uses frequently.
