ALTER TABLESPACE RENAME Clause

Use this clause to rename tablespace. This clause is valid only if tablespace and
all its datafiles are online and the COMPATIBLE parameter is set to 10.0.0 or greater.
You can rename both permanent and temporary tablespaces.

表空间的数据文件都需要online , 并且初始化参数COMPATIBLE需要设置>=10.0.0 .
永久性和临时性的表空间都可以重命名。

If tablespace is read only, then Oracle Database does not update the datafile
headers to reflect the new name. The alert log will indicate that the datafile headers
have not been updated.

表空间只读时，数据文件头没有被更新。警告日志中会有该警告信息。

Note: If you re-create the control file, and if the datafiles that Oracle
Database uses for this purpose are restored backups whose headers
reflect the old tablespace name, then the re-created control file will
also reflect the old tablespace name. However, after the database is
fully recovered, the control file will reflect the new name.

当重建控制文件时，当转储的备份文件文件头为旧的表空间名称时，那么重建的控制文件也映射为旧的
表空间名称。当数据库全部恢复后，重建的控制文件将映射为新的表空间名称。

If tablespace has been designated as the undo tablespace for any instance in a Real
Application Clusters environment, and if a server parameter file was used to start up
the database, then Oracle Database changes the value of the UNDO_TABLESPACE
parameter for that instance in the server parameter file (SPFILE) to reflect the new
tablespace name. If a single-instance database is using a parameter file (pfile) instead
of an spfile, then the database puts a message in the alert log advising the database
administrator to change the value manually in the pfile.

在RAC环境中，如使用SPFILE启动数据库，如一表空间被指派为回滚表空间，那么Oracle将改改变UNDO_TABLESPACE
的值。在单实例中，如使用PFILE，Oracle会在预警日志中给出日志建议DBA手工更改PFILE文件中的参数值。

Restriction on Renaming Tablespaces ：You cannot rename the SYSTEM or SYSAUX tablespaces.

重命名表空间限制 ：不能对SYSTEM和SYSAUX表空间重命名。

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10599713/viewspace-1001694/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10599713/viewspace-1001694/