Rename Tablespace in Oracle database 10g

最新推荐文章于 2025-12-11 22:46:37 发布

转载最新推荐文章于 2025-12-11 22:46:37 发布 · 96 阅读

文章标签：

#数据库

在Oracle10g中，除SYSTEM和SYSAUX外，其他永久及临时表空间可通过ALTERTABLESPACE命令进行重命名。进行此操作时，表空间及其所有数据文件必须在线，且数据库的兼容性设置需为10.0.0或更高。

Renaming permanent and temporary tablespaces is now allowed in Oracle 10g (except for SYSTEM and SYSAUX) using the following command.

ALTER TABLESPACE ts_current_name RENAME TO ts_new_name;

The tablespace and all it's datafiles must be online and the database must have a COMPATIBLE setting of 10.0.0 or greater.

If the tablespace is read-only the datafile headers are not altered to reflect the name change and a message is written to the alert log to notify you of this fact. The impact on recovery is that the tablespace will be recovered to it's old name if the controlfile is recreated and datafiles containing the old headers are used.

If an undo tablespace is renamed in a instance which uses a pfile, rather than an spfile, a message is written to the alert log reminding you to change the value of the UNDO_TABLESPACE parameter.

[@more@]

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

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