Re: dbschema with fragment expressions?

Alan Caldera wrote: > Matthew, > dbschema -d <database> -ss filename.sql> > The key of course is -ss (server specific). All dbspaces and frag expressions as well as extent and > locklevel info will be output as part of the .sql file. > > HTH, > Alan > > "Matthew H. Devlin III" wrote: > > > how can I get a shema of the database that reflects the fragmentation > > expressions I have in place? If there is no way with dbschema is there > > another way? We have over 500 tables in the database with about 100 of > > them fragmented and I don't want to have to rewrite the fragments. sweet! thanks for the help!