Which four tablespaces can be renamed? (Choose four.)
A.
an undo tablespace
B.
an offline tablespace
C.
a read-only tablespace
D.
a temporary tablespace
E.
the SYSTEM tablespace
F.
the default permanent tablespace for the non-SYSTEM users
Explanation:
Besides any other, The COMPATIBLE parameter must be set to 10.0 or higher. A – True. UNDO Tablespace. 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 bemanually changed.
B – False. Offline Tablespaces. If any datafile in the tablespace is offline, or if the tablespace is offline, then the tablespace is not renamed and an error is raised. C – True. Read-only Tablespace. If the tablespace is read only, then datafile headers are not updated. This should
not be regarded as corruption; instead, it causes a message to be written to the alert log indicating that datafile headers have not been renamed. The data dictionary and control file are updated.
D – True.Temporary Tablespace.If the tablespace is the default temporary tablespace, then the corresponding entry in the database properties table is updated and the DATABASE_PROPERTIES view
shows the new name.
E – False. SYSTEM Tablespace. If the tablespace being renamed is the SYSTEM tablespace or the SYSAUX
tablespace, then it will not be renamed and an error is raised. F – True. When you rename a tablespace the database updates all references to the tablespace name in the data dictionary, control file, and (online) datafile headers. The database does not change the tablespace ID so if this tablespace were, for example, the default tablespace for a user, then the renamed tablespace would show as the default tablespace for the user in the DBA_USERS view.
REF.: Oracle(r) Database Administration Guide,8-19