undo_tablespace

最新推荐文章于 2024-07-18 08:15:00 发布

lixora

最新推荐文章于 2024-07-18 08:15:00 发布

阅读量484

点赞数

分类专栏：学习笔记

本文链接：https://blog.csdn.net/lixora/article/details/8550567

版权

学习笔记专栏收录该内容

204 篇文章 0 订阅

订阅专栏

undo_tablespace

Property              Description
Parameter type       String
Syntax              UNDO_TABLESPACE = undoname
Default value         The first available undo tablespace in the database.
Modifiable           ALTER SYSTEM
Range of values     Legal name of an existing undo tablespace
Basic               Yes
Oracle RAC Each instance must have a unique value for this parameter, when it is
set

这个参数在manual的undo管理下不用使用否者会在报错，并且不能startup。只在auto下有效

If the UNDO_TABLESPACEparameter is omitted, the first available undo tablespace in
the database is chosen. If noundo tablespace is available, the instance will start
without an undo tablespace. In such cases, user transactions will be executed using the
SYSTEMrollback segment. You should avoid running in this mode under normal
circumstances.
You can replace an undo tablespace with another undo tablespace while the instance is
running.