RENAME TO clause of the
ALTER TABLESPACE, you can rename a permanent or temporary tablespace.
For example, the following statement renames the
ALTER TABLESPACE t_old RENAME TO t_new;
When you rename a tablespace the database updates all references to the tablespace name in the data dictionary, control file, and (online) data file 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
The following affect the operation of this statement:
- If the tablespace being renamed is the
SYSTEMtablespace or the
SYSAUXtablespace, then it will not be renamed and an error is raised.
- If any data file in the tablespace is offline, or if the tablespace is offline, then the tablespace is not renamed and an error is raised.
- If the tablespace is read only, then data file 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 data file headers have not been renamed. The data dictionary and control file are updated.
- If the tablespace is the default temporary tablespace, then the corresponding entry in the database properties table is updated and the
DATABASE_PROPERTIESview shows the new name.
- 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 (
- The server parameter file was used to start up the database.
- The tablespace name is specified as the
UNDO_TABLESPACEfor any instance.
PFILE) is being used then a message is written to the alert log stating that the initialization parameter file must be manually changed.