how to do cluster index move to diffrant tablespace
My data base is 9.2.0.8. I have cluster index and table which have consiume large space. i need to re-org table and index and move to dirant tablespace.
SQL> select TABLE_NAME,CLUSTER_NAME from dba_tables where TABLESPACE_NAME='RAPID_TAB_TS_1';
TABLE_NAME CLUSTER_NAME
------------------------------ ------------------------------
TAP3ROAMERDATA C_TAP3ROAMERDATA
SQL> select table_name,index_name,index_type from dba_indexes where index_name='TAP3ROAMERDATA_CK';
TABLE_NAME INDEX_NAME INDEX_TYPE
------------------------------ ------------------------------ ---------------------------
C_TAP3ROAMERDATA TAP3ROAMERDATA_CK CLUSTER
pl let me know this table and index how to move to diffrant tablespace