Re: Maxextent value altered

set feedback off heading off pagesize 0 termout off spool maxext.sql
select 'prompt table '||table_name||chr(10)||'alter table '||table_name||' storage (maxextents <anything>);'
from user_tables
union
select 'prompt index '||index_name||chr(10)'alter index '||index_name||' storage (maxextents <anything>);'
from user_indexes
spool off
set termout on feedback on pagesize 24 heading on spool maxext.log
start maxext.sql
spool off

This should be all.

Hth,

Sybrand Bakker, Oracle DBA

<xo55ox_at_hotmail.com> wrote in message news:7phbf0$3mr$1_at_nnrp1.deja.com...
> Hi,
>
> I need to alter the maxextent value for some tables and indexes down at
> the object level. And I know that I can do that under SQL*Plus by typing
> in the command. However, I have about few thousand tables and indexes I
> need to be altered. I wonder is there a quicker way to do that. Can
> somebody help please?
>
> Thanks in advance.
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Thu Aug 19 1999 - 12:24:17 CDT