Saturday, 27 August 2016

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.

No comments:

Post a comment