Quote Originally Posted by yxez
ma'm correction....well, if i were in ur place i'll drop and recreate
the indexes pointing to the new tablespace, its faster than rebuilding....based on my experience
Drop and re-create will mean you are doing a full table scan of the table the index is based on.

Rebuilding (provided you have the space to do it), will do a fast full scan of the index (assuming Oracle can read all the blocks).

I'd rebuild it if I could.