> Home > Scripts > Oracle >

Generate a script to set index size to unlimited extents

This script should be run from SQL*plus prompt. This can also be placed in a file and ran from the SQL*plus prompt.

 

SET spool modify_idx_unlimted_ext.sql

SET head off

SET pagesize 0

SELECT 'alter index '

        ||index_name 

        ||' STORAGE ( maxextents unlimited );' 

FROM user_indexes

/

SET spool off

@modify_idx_unlimited_ext.sql

/

exit

/