In the SPFILE, UNDOJTABLESPACEis Set to UNDOTBS. You rename the undotbs undo
tablespace: ALTER TABLESPACE undotbs RENAME TO undotbs_old; Which statement is
true?
A.
The tablespace will be renamed but the data file headers will not be updated.
B.
The statement will fail because you cannot rename an undo tablespace.
C.
The tablespace will be renamed and all the changes will be logged in the alert log.
D.
The tablespace will be renamed and a message written to the alert log indicating that you
should change the corresponding initialization parameter.
E.
You must set the undo_tablespace parameter to some other tablespace name before
renaming undotbs.
E
Database started by SPFile contains a record for UNDO thus I Think “C” is the right answer, the following is my reference:
If the tablespace is an undo tablespace and if the following conditions are met, then the tablespace name is changed to the new tablespace name in the server parameter file (SPFILE).
The server parameter file was used to start up the database.
The tablespace name is specified as the UNDO_TABLESPACE for any instance.
11g R1 DBA Guide “B28359_01”
https://docs.oracle.com/cd/B28359_01/server.111/b28310/tspaces008.htm
C
C.
In my lab (12.1.0.1):
SQL> select tablespace_name from dba_tablespaces;
TABLESPACE_NAME
——————————————————————————–
SYSTEM
SYSAUX
UNDOTBS1
TEMP
USERS
COMUN
6 rows selected.
SQL> alter tablespace UNDOTBS1 rename to UNDOTBS1_OLD;
Tablespace altered.
Meanwhile, in alert.log:
Thu Aug 18 12:13:32 2016
alter tablespace UNDOTBS1 rename to UNDOTBS1_OLD
Thu Aug 18 12:13:32 2016
Tablespace ‘UNDOTBS1’ is renamed to ‘UNDOTBS1_OLD’.
Completed: alter tablespace UNDOTBS1 rename to UNDOTBS1_OLD