Oracle9i Database Reference Release 2 (9.2) Part Number A96536-02 |
|
|
View PDF |
Parameter type |
Boolean |
Default value |
|
Parameter class |
Dynamic: |
Range of values |
|
UNDO_SUPPRESS_ERRORS
enables users to suppress errors while executing manual undo management mode operations (for example, ALTER ROLLBACK SEGMENT ONLINE
) in automatic undo management mode. Setting this parameter enables users to use the undo tablespace feature before all application programs and scripts are converted to automatic undo management mode. For example, if you have a tool that uses SET TRANSACTION USE ROLLBACK SEGMENT
statement, you can add the statement "ALTER SESSION SET UNDO_SUPPRESS_ERRORS = true
" to the tool to suppress the ORA-30019 error.
If you want to run in automatic undo management mode, ensure that your tools or applications are updated to run in automatic undo management mode.