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.
It should only be C. This has been true since version 10. community.oracle.com/thread/860786
C
https://docs.oracle.com/cd/B28359_01/server.111/b28310/tspaces008.htm
C
C
It’s C. Thank you. It is possible due to below technique,
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.
If a traditional initialization parameter file (PFILE) is being used then a message is written to the alert log stating that the initialization parameter file must be manually changed
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
C