Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Is Automatic Undo Management compatible with existing applications or scripts designed to use rollback segments?

April 26, 2017applications automatic compatible designed existing Management Rollback scripts segments undo

0

Posted

Is Automatic Undo Management compatible with existing applications or scripts designed to use rollback segments?

1 Answer

0

Posted

By default, any command related to rollback segments will fail in Oracle9i with an error message while using Automatic Undo Management. The idea behind this behavior is to make users aware of obsolete commands and facilitate changing the script/application. However, it is possible to direct Oracle9i to suppress such errors by setting a new init.ora parameter (UNDO_SUPPRESS_ERRORS) in which case Oracle will ignore any command related to rollback segments usage while using Automatic Undo Management.