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 / |