-- ************************************************************
-- *** Feel free to use this SQL-code, but please           ***
-- *** do not remove these copyright lines.                 ***
-- *** (C) Roger Felix - Lund - Sweden                      ***
-- *** [roger_felix@hotmail.com, web_master@work.utfors.se] ***
-- *** URL: http://hem.fyristorg.com/publish/index.html     ***
-- ************************************************************

set linesize 500
set heading off
set pagesize 500
set trimspool on;
set arraysize 1;
select 'alter INDEX '||owner||'.'||index_name||' rebuild'||
  ' PCTFREE '||PCT_FREE||
  ' INITRANS '||to_char(INI_TRANS)||
  ' MAXTRANS '||to_char(MAX_TRANS)||
  ' TABLESPACE '||TABLESPACE_NAME||
  ' STORAGE (INITIAL '||to_char(INITIAL_EXTENT)||
  ' NEXT '||to_char(NEXT_EXTENT)||
  ' PCTINCREASE '||to_char(PCT_INCREASE)||
  ' MINEXTENTS '||to_char(MIN_EXTENTS)||
  ' MAXEXTENTS '||to_char(MAX_EXTENTS)||');'
from all_indexes
   order by owner, index_name;