Benefits of using Read only tablespaces
August 21st, 2008 12:35 pm
Read only tablespaces are one of the main weapons in the battle to reduce the amount of data that needs to be backed up. Having the ability to mark certain area of the database as being read-only is vital Making a tablespace read-only means the tablespace cannot be changed even accidentally, without bringing it back to a read-write state. Therefore, the table space can be backed up once and stored somewhere safe, and it does not have to be backed up again.
