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
|
Results 1 to 7 of 7
Thread: script to rebuild all indexesThreaded View
|
Click Here to Expand Forum to Full Width |