Re: dbschema and preserving extents and dbspaces.

pjhaveri@treas02.attmail.com (pjhaveri) writes: > > Hi, > I am using 7.11 and I get dbspace and extent size, lock mode and next extent > size. when I use dbschema with -ss option. > > Regards, > priti > > >I am running 7.10 and 7.12. I do not get the dbspace only the extents when > >I use the -ss option. Can someone check and tell me if they get the dbspace? > > Steve Berg - spb@masada.nb.com > The dbspace will only show up if you specifically specified one upon table creation. e.g.: If you use the following syntax for creating two tables: create table table_one (junk char(10)); create table table_two (stuff char(10)) in dbspace2; Then the dbspace for "table_two" will appear in the dbschema, but not for "table_one". "table_one" will get allocated in the default dbspace of the database if the dbschema is executed. dbexport/dbimport work the same way. HTH Irwin Goldstein Objective Software Systems, Inc.