Why read only tablespace is required in Oracle

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.