undo_tablespace

undo_tablespace

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

<wbr></wbr>

这个参数在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.