Rebuild Index in a Oracle Schema

spool index_rebuild.sql
select 'alter index '||owner||'.'||index_name ||' rebuild online nologging;'
from dba_indexes
where owner=upper('SIFSAPP');
spool off

locate broken index use:

select index_name,index_type,status,domidx_status,domidx_opstatus from user_indexes 
where index_type like '%DOMAIN%' and (domidx_status <> 'VALID' or domidx_opstatus <> 'VALID');
To rebuild the index use:

alter index INDEX_NAME rebuild;