I wnat to find out how to move indexes from one tablespace to another and rebuilding them at the same time without recreating them
ALTER INDEX index_name REBUILD TABLESPACE tablespace_name;
That will work...
Thanks very much. I am yet to see the whether performance has improved.