Re: How to alter table storage on all tables

From: Alistair Thomson <thomson_alistair_at_yahoo.co.uk>
Date: Tue, 17 Sep 2002 16:24:08 +0100
Message-ID: <am7hes$qaq$1$8300dec7@news.demon.co.uk>

try

select 'alter table '||table_name||' storage (next 1m pctincrease 0);' from user_tables;

spool it out to a file and run it.

Alistair

"DepsiBob" <depsibob_at_yahoo.se> wrote in message news:e1ae410.0209170708.13010904_at_posting.google.com...
> Hi,
>
> I want to change some storage params for all tables in a schema,
> but how do you write a sql that does this change on all tables?
> (Want to change NEXT and PCTINCREASE on all tables).
>
> //DepsiBob
Received on Tue Sep 17 2002 - 10:24:08 CDT