Re: Safe way to drop and re-create table?

stuartk@au1.ibm.com wrote: > > Also bear in mind that dbschema does not report on the dbspace that a table > resides in (even with the > -ss option). Actually it does, unless the table resides in the same dbspace as the database was created in, which is the default dbspace for new tables in that database anyway. So while it does not document well, dbschema is OK for this purpose anyway, Stuart. > If the reason you want to drop/recreate is to resize the table, I would > recommend Art Kagel's "myschema.ec" as this does report on the dbspaces, and can > calculate the optimum sizes of the extents, > based on the data in the table. Thanks for the plug. Actually the functionality that Strangiato is looking for is on my list of new features for myschema since I edit schemas constantly to do just what he is doing (break schema into separate create and index scripts). As soon as I finish the rewrite needed to support SE servers (95% done now) I tackle that one next. Too late for our friend but nice to know. [SNIP] Art S. Kagel

Art S. Kagel (kagel@bloomberg.net) wrote: : Actually the functionality that Strangiato is looking for is on my list of : new features for myschema since I edit schemas constantly to do just what : he is doing (break schema into separate create and index scripts). As : soon as I finish the rewrite needed to support SE servers (95% done now) I : tackle that one next. Too late for our friend but nice to know. : Art S. Kagel How about IUS? :) Specifically inheritance and UDTs, of course. -- Rob Wilson rwilson@ntsource.com