Wednesday, June 29, 2011

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;

No comments:

Post a Comment