Posted on Leave a comment

Rebuild index to index tablespace

SELECT ‘alter index MYPROJ.’ || index_name || ‘ rebuild tablespace MYPROJINDX;’
FROM dba_indexes
WHERE owner = ‘MYPROJ’
AND tablespace_name != ‘MYPROJINDX’
ORDER BY index_name;

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.