My Oracle Support Banner

Which Operations are Allowed or Prohibited on RBS with or without AUM? (Doc ID 135217.1)

Last updated on JANUARY 30, 2022

Applies to:

Oracle Database - Enterprise Edition - Version 8.1.7.0 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.

Purpose

This bulletin shows the errors you would encounter when you attempt to use operations on rollback segments whether you are in Automatic Undo Management (AUM) mode or not.

It explains the reasons for the restrictions applied on rollback segment management.

The error messages always specify which mode the operations takes place in:
 
   * Automatic Undo Management
   * Manual Undo Management
 
NOTE:   Bug 2969493 (not published in Metalink) indicates that there are changes at 10g, and even though the create fails, you will no longer get the error messages.  
            This was closed as not a bug, because when using automatic undo management, you should create rollback segments directly.

 

Scope

For DBAs who are used to managing the rollback segments of a database manually and who now have to consider the existence of AUM (Automatic Undo Management).


Which operations are allowed or prohibited on rollback segments when you are using or not using AUM?  

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.