Difference between revisions of "Local Undo"

From Robs_Wiki
Jump to: navigation, search
(Created page with "<pre> COLUMN property_name FORMAT A30 COLUMN property_value FORMAT A30 SELECT property_name, property_value FROM database_properties WHERE property_name = 'LOCAL_UNDO_ENAB...")
 
Line 1: Line 1:
 +
__TOC__
 +
== Change from shared to local undo ==
 
<pre>
 
<pre>
 
COLUMN property_name FORMAT A30
 
COLUMN property_name FORMAT A30
Line 30: Line 32:
 
------------------------------ ------------------------------
 
------------------------------ ------------------------------
 
LOCAL_UNDO_ENABLED            TRUE
 
LOCAL_UNDO_ENABLED            TRUE
 +
</pre>
 +
== 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>
 
</pre>

Revision as of 16:35, 4 October 2020

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>