Fazer rebuild de índices de um schema

set pagesize 0
set feedback off
spool ri.sql
select 'alter index '||owner||'.'||index_name||' rebuild tablespace'|| tablespace_name||';'
from dba_indexes
where owner = upper('&Informe_schema');
spool off
set pagesize 20
set linesize 120
set feedback on