Originally posted by bal
How do you set max extents unlimited for all user tables and or objects
SQL> SET HEADING OFF
SQL> SET PAGESIZE 1000
SQL> SPOOL MAX_EXTENTS_UNLIMITED.SQL

SQL> select 'alter table '||owner||'.'||table_name||' storage(maxextents unlimited);'
2 from dba_tables
3 where owner='TABLE_OWNER_YOU_WANT_TO_ALTER;

SQL> SPOOL OFF


Who do you love?

MH