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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment