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
... but more error prone and difficult to code, I'd say