sqlforge
We've moved to http://sqlforge.us/blog/
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
‹
›
Home
View web version
No comments:
Post a Comment