How to rename a Tablespace | Oracle Database

How to rename a Tablespace in Oracle Database

Using the RENAME TO clause of the ALTER TABLESPACE, you can rename a permanent or temporary tablespace. For example, the following statement renames the users tablespace:

ALTER TABLESPACE TAB1 RENAME TO TAB11;

The following affect the operation of this statement:

• The COMPATIBLE parameter must be set to 10.0 or higher.
• If the tablespace being renamed is the SYSTEM tablespace or the SYSAUX tablespace, then it will not be renamed and an error is raised.
• 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.