Re: Maxextent value altered

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Fri, 20 Aug 1999 03:44:20 GMT
Message-ID: <37c1c2c0.50032362@netnews.worldnet.att.net>

On Thu, 19 Aug 1999 16:30:23 GMT, xo55ox_at_hotmail.com wrote:

>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?

If you are making the same alteration to all those tables, you can do something like this from SQL*Plus

spool change_maxextents.sql
select 'alter table ' || table_name

        || '' storage (maxextents 999); "
from dba_tables
where

        put your own critera heer
/
spool off

@change_maxextents.sql

You might want to review the file before you execute it. The same technique can be used to generate alter index commands from the dba_indexes table.

Jonathan

---

jonathan_at_gennick.com
http://gennick.com
Brighten the Corner Where You Are Received on Thu Aug 19 1999 - 22:44:20 CDT