script to rebuild all indexes

[akkerend]

set pages 1000
set lines 1000
set echo off
set heading off
set feedback off

spool rebuild.sql

SELECT 'ALTER INDEX '||owner||'.'||index_name||' REBUILD;'
FROM dba_indexes
WHERE owner = 'SCOTT';

spool off