rem rem Make pctincrease on tablespaces to 0 rem set echo off feedback off verify off pages 0 termout off spool /tmp/makepct0.sql SELECT 'alter tablespace ' || tablespace_name || ' default storage (pctincrease 0);' FROM dba_tablespaces WHERE pct_increase > 0; rem rem Make pctincrease on tables to 0 rem SELECT 'alter table ' || owner ||'.'|| table_name || ' storage (pctincrease 0);' FROM dba_tables WHERE pct_increase > 0 AND owner != 'SYS'; rem rem Make pctincrease on indexes to 0 rem SELECT 'alter index ' || owner ||'.'|| index_name || ' storage (pctincrease 0);' FROM dba_indexes WHERE pct_increase > 0 AND owner != 'SYS'; spool off set feedback on verify on pages24 echo on termout on spool pct0.lst @/tmp/makepct0.sql spool off set echo off