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;