How to Switch/Recreate Undo Tablespace at PDB Level (Doc ID 2560841.1)

Last updated on APRIL 17, 2023

Applies to:

Goal

How to Switch/Recreate Undo Tablespace at PDB level

-------------------------------------------------------------

SQL> SELECT property_name, property_value FROM database_properties WHERE property_name = 'LOCAL_UNDO_ENABLED';  

PROPERTY_NAME                  PROPERTY_VALUE
------------------------------ ------------------------------
LOCAL_UNDO_ENABLED             TRUE

show parameter undo;

NAME              TYPE    VALUE    
----------------- ------- -------- 
temp_undo_enabled boolean FALSE    
undo_management   string  AUTO     
undo_retention    integer 5        
undo_tablespace   string  UNDOTBS1

Solution

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