EBS : Checking the INVALID indexes for a particular tablespace and rebuilding it

Here we check for APPS_TS_QUEUES tablespace and rebuild the indexes

select index_name,status from dba_indexes where tablespace_name='APPS_TS_QUEUES' and STATUS != 'VALID';

Above query gives the indexes which are INIVALID in APPS_TS_QUEUES tablespace

select 'alter index 'owner'.'index_name' rebuild;' from dba_indexes where tablespace_name='APPS_TS_QUEUES' and STATUS != 'VALID';

Get the output from the above query and run to rebuild it