Assignment of Undo Tablespaces (43)

最新推荐文章于 2025-12-08 09:18:56 发布

转载最新推荐文章于 2025-12-08 09:18:56 发布 · 72 阅读

文章标签：

#数据库

本文介绍如何在实例启动时或运行中指定Undotablespace，包括通过初始化参数或动态更改设置的方法。此外还介绍了如何增加Undotablespace的空间及如何使用资源管理器设置用户配额。

You assign an undo tablespace to an instance in one of two ways:
1 At instance startup. You can specify the undo tablespace in the initialization file or
let the system choose an available undo tablespace.
2 While the instance is running. Use ALTER SYSTEM SET UNDO_TABLESPACE to
replace the active undo tablespace with another undo tablespace. This method is
rarely used.
You can add more space to an undo tablespace by adding more datafiles to the undo
tablespace with the ALTER TABLESPACE statement.
You can have more than one undo tablespace and switch between them. Use the
Database Resource Manager to establish user quotas for undo tablespaces. You can
specify the retention period for undo information.

1 两种方法指定回滚表空间
a 在实例启动时，通过参数文件的undo_tablespace指定
b 实例运行时，使用alter system set undo_tablespace <>
2 可以拥有超过1个的undo tb , 并且可以切换

[@more@]

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

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