MOVE INDEX TBS | Rebuild Index

SET SERVEROUTPUT ON
SET FEEDBACK ON VERIFY ON HEADING ON ECHO ON TIMING ON
SPOOL MoveIndexTBS.log

BEGIN
FOR rec_indexes IN (
SELECT OWNER, INDEX_NAME, TABLESPACE_NAME
FROM ALL_INDEXES
WHERE TABLESPACE_NAME NOT IN ('SYSAUX','SYSTEM','STV_INDEX')
)
LOOP
BEGIN
EXECUTE IMMEDIATE 'ALTER INDEX '||rec_indexes.OWNER||'.'||rec_indexes.INDEX_NAME||' REBUILD TABLESPACE STV_INDEX';
DBMS_OUTPUT.PUT_LINE('Index '||rec_indexes.OWNER||'.'||rec_indexes.INDEX_NAME||' rebuilt successfully!!!');
EXCEPTION WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE('Unable to rebuild index '||rec_indexes.OWNER||'.'||rec_indexes.INDEX_NAME||' with SQL Error '||SQLERRM);
END;
END LOOP;
END;
/

SPOOL OFF