Saturday, 3 February 2007

Oracle 10g Moving Data across tablespaces

Moving a table named my_table to a new tablespace named dest_data is a new feature of Oracle 10g and can be accomplished using the following command in SQLPlus:
SQL> alter table my_table move tablespace my_data;
Moving an index to a different table space is performed as follows :
SQL>alter index my_index rebuild tablespace my_data;

No comments :