ALTER TABLESPACE users RENAME TO usersts;
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
The following affect the operation of this statement:
COMPATIBLE parameter must be set to 10.0.0 or higher.
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.
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.
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.