Friday, May 20, 2011

Rebuilding Indexes


select 'ALTER INDEX '|| index_name ||' REBUILD TABLESPACE INDX;’ from USER_INDEXES -- TO GET ALL THE INDEXES

alter system enable restricted  session;


Run the indexes rebuild script

alter system disable restricted  session;





No comments:

Post a Comment