Re: Maxextent value altered

What I do in these cases is use oracle to create my script for me. First I write a script like this

rem - script to create script
set pages 0;
set feedback off;
set termout off;
spool doit.sql
select 'alter table '||table_name||' storage(maxextents 249);' from user_tables
order by table_name;
exit;

This produces a script called doit.sql with a whole list of sql statements which I can then run to perform the changes en-masse.

Ken

xo55ox_at_hotmail.com wrote:

> 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:25:40 CDT