Using Automatic Undo Management: Creating an Undo Tablespace (73)

转载于 2007-12-24 15:37:20 发布 · 94 阅读

文章标签：

本文介绍如何通过设置UNDO_MANAGEMENT参数为AUTO启用Oracle数据库的自动回滚管理功能。在此模式下，回滚数据将被存储在指定的回滚表空间中，并由数据库自身进行管理。若未指定UNDOTABLESPACE子句，则会自动生成名为SYS_UNDOTBS的默认回滚表空间。

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

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10599713/viewspace-995634/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10599713/viewspace-995634/