Re: How to alter table storage on all tables

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Tue, 17 Sep 2002 15:31:35 GMT
Message-ID: <3D874AA1.E311E7CB@exesolutions.com>

DepsiBob wrote:

> 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

Write an anonymous block with a cursor. The cursor selects tablenames from user_tables or all_tables and then create your alter table statement as a string and execute it with native dynamic SQL. Look up "EXECUTE IMMEDIATE" and "NATIVE DYNAMIC SQL" at http://tahiti.oracle.com.

Daniel Morgan Received on Tue Sep 17 2002 - 10:31:35 CDT