Using Automatic Undo Management: Creating an Undo Tablespace (73)
Automatic undo management uses an undo tablespace.To enable automatic undo
management, set the UNDO_MANAGEMENT initialization parameter to AUTO in your
initialization parameter file. In this mode, undo data is stored in an undo tablespace
and is managed by Oracle Database. If you want to define and name the undo
tablespace yourself, you must also include the UNDO TABLESPACE clause in the
CREATE DATABASE statement at database creation time. If you omit this clause, and
automatic undo management is enabled (by setting the UNDO_MANAGEMENT
initialization parameter to AUTO), the database creates a default undo tablespace
named SYS_UNDOTBS.
使用自动管理回滚表空间 : 创建回滚表空间
1. 指定UNDO_MANAGEMENT参数化参数值为AUTO
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10599713/viewspace-995634/ ，如需转载，请注明出处，否则将追究法律责任。
-
博文量740
-
访问量2002851
最新文章
- 人力&人手&人才&人物
- 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
- 目睹奥运火炬传递
