Local Undo

From Robs_Wiki
Revision as of 16:35, 4 October 2020 by Qadmin wiki (talk | contribs)
Jump to: navigation, search

Change from shared to local undo

COLUMN property_name FORMAT A30
COLUMN property_value FORMAT A30

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

PROPERTY_NAME                  PROPERTY_VALUE
------------------------------ ------------------------------
LOCAL_UNDO_ENABLED             FALSE

Now change to LOCAL_UNDO

CONN / AS SYSDBA

SHUTDOWN IMMEDIATE;
STARTUP UPGRADE;

ALTER DATABASE LOCAL UNDO ON;

SHUTDOWN IMMEDIATE;
STARTUP;

Check the UNDO again:

SQL> @cdb_check_undo

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

change from local to shared undo

This is just a reverse operation, although there is no reason you would want shared undo.<br / All steps are the same, just use "ALTER DATABSE LOCAL UNDO OFF" as opposed to ON. </pre>