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
Printable View
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
You can rebuild the indexes specifying a new tablespace:
You should do this off-hours to avoid performance problems when the index is being rebuilt.Code:alter index xyz rebuld tablespace new_tbs;
Thanx a lot...
ALTER INDEX index_name REBUILD TABLESPACE tablespace_name;
REBUILD will move the index from existing tablespace to new tablespace that you mention.