Database Administration (MOSC)

MOSC Banner

how to do cluster index move to diffrant tablespace

edited Feb 9, 2011 6:59AM in Database Administration (MOSC) 16 commentsAnswered
 hi,

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center