Re: dbexport, dbschema do not keep chunk, blob info. Bug? Feature?

> > Fellow Informix'ers, > > dbexport and dbschema do not keep the table space information for tables, > nor the extent information. We have tables that go to a table space different > from rootdbs. So if we dbexport, and then a dbimport, the tables get imported > to a wrong table space. > > Is this a bug or a feature? One of the tables has blob columns. This > info however, is retained by the utilities. > > Any and all responses on this amtter appreciated. Have you checked out a little utility called pres_ext? It should be hiding out on the archives. It is a shell which generates a schema which retains dbspace names and extent information. You can just replace the dbimport sql file with it. Or you can upgrade to 6.0 where all that is taken care of. If you want the script and can't get it easily from the archives, let me know, I have a copy around here somewhere. cheers j. _____________________________________________________________________________ Jack Parker | Hewlett Packard, BSMC Boise, Idaho, USA| No soap - radio! jparker@hpbs3645.boi.hp.com | _____________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. _____________________________________________________________________________