> Home > Scripts > Oracle >

Generate a script to set table 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_tbls_unlimted_ext.sql

SET head off

SET pagesize 0

SELECT 'alter table '|| 

          table_name || 

       ' STORAGE ( maxextents unlimited );' 

FROM user_tables

/

SET spool off

@modify_tbls_ulimited_ext.sql

/

exit

/