Oracle Database Appliance (ODA) (MOSC)

MOSC Banner

undo_tablespace

Hello,

i'm trying to drop/create a new undo_tablespace at my oracle db version 12.1.0 by following the below command

***********************************************************************

sqlplus / as sysdba

CREATE UNDO TABLESPACE UNDOTBS2; 

alter system set undo_tablespace='UNDOTBS2' scope=BOTH;

DROP TABLESPACE UNDOTBS1 INCLUDING CONTENTS AND DATAFILES;

show parameter undo


NAME                 TYPE    VALUE

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

_gc_undo_affinity          boolean   FALSE

temp_undo_enabled          boolean   FALSE

undo_management           string   AUTO

undo_retention            integer   900

undo_tablespace           string   UNDOTBS2


==> till now everything is fine

now i restarted the database and immediately check show parameter undo

==>i noticed that it returned back to UNDOTBS1

SQL> show parameter undo

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center