Re: How to alter table storage on all tables

From: Richard Spee <rhpspee_at_wxs.nl>
Date: Tue, 17 Sep 2002 19:41:22 +0200
Message-ID: <am7ptj$s5t$1@reader12.wxs.nl>

Another option would be to group your tables and indexes with similar characteristics in a seperate tablespace with a default storage clause. Just one statement is needed to change for example pctincrease of all new extents.

If a table or index no longer fits tablespaces characteristics just move it to another tablespace.

"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).
>
> file://DepsiBob
Received on Tue Sep 17 2002 - 12:41:22 CDT