Indexes

[helpme]

Hi,
By mistake some of the indexes have been stored into the users table space..
Now i want to move it to the indx table space....

How can i do it...and Will it create any problem..

Thanx

[marist89]

You can rebuild the indexes specifying a new tablespace:

alter index xyz rebuld tablespace new_tbs;

You should do this off-hours to avoid performance problems when the index is being rebuilt.

[helpme]

Thanx a lot...

[ggnanaraj]

ALTER INDEX index_name REBUILD TABLESPACE tablespace_name;

REBUILD will move the index from existing tablespace to new tablespace that you mention.