The primary purpose of read-only tablespaces is to eliminate the need to perform
backup and recovery of large, static portions of a database. Oracle never updates the
files of a read-only tablespace, and therefore the files can reside on read-only media
such as CD-ROMs or WORM drives.
Read-only tablespaces cannot be modified. To update a read-only tablespace, first
make the tablespace read/write. After updating the tablespace, you can then reset it to
be read only.
Because read-only tablespaces cannot be modified, and as long as they have not been
made read/write at any point, they do not need repeated backup. Also, if you need to
recover your database, you do not need to recover any read-only tablespaces, because
they could not have been modified.
只读表空间
1. 这样的表空间不需要备份恢复 ， 不会被更新 ， 可以驻留在只读介质上
2. 如果需要修改只读表空间 ， 首先需要将该表空间更改为读写模式 ， 完成手 ， 可以重新设置为只读
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10599713/viewspace-975636/ ，如需转载，请注明出处，否则将追究法律责任。
-
博文量740
-
访问量2002856
最新文章
- 人力&人手&人才&人物
- oracle树中prior的用法
- Using Supplied Packages to Manage Stored Outlines
- $ORACLE_HOMERDBMSADMIN目录下各SQL的含义
- PRODUCT_USER_PROFILE Table
- Backing Up Server Parameter Files with RMAN
- Backing Up Control Files with RMAN
- Backing Up Individual Tablespaces with RMAN
- Making Whole Database Backups with RMAN
- 目睹奥运火炬传递
