Hey Guys,

I created Script that will rebuild indexes per schema. I wanted to post for others to enjoy.

BEGIN
FOR INDEx_RECORD IN (select 'SCHEMA_NAME.'||object_name as obj
from dba_objects
where object_type = 'INDEX' and
owner ='SCHEMA_NAME'
) LOOP
execute immediate 'ALTER INDEX '||INDEx_RECORD.obj||' REBUILD';
END LOOP; -- implicit CLOSE occurs
END;