Rename Tablespace

http://www.dba-oracle.com/art_dbazine_ault_temp_tablespace.htm

Another great new feature in tablespace management is rename tablespace.

Tablespace Rename Overview

In Oracle 10g, you can simply rename a tablespace TBS01 to TBS02 by issuing the following command:

Tablespace Rename Benefits

Tablespace rename provides the following benefits:

• It simplifies the process of tablespace migration within a database.
• It simplifies the process of transporting a tablespace between two databases.

ALTER TABLESPACE RENAME old_tbs to new_tbs;

ORACLE 10G以後針對TABLESPACE 提供更好的支援

和簡單的語法

有時候因為效能和重整DB的ISSUE 必須要作搬動

越是彈性且操作不複雜的方式

將可以讓DBA 更有時間對於檔案有更多的時間做最有效的規劃