Re: DBExport

Robertson Lee NTSE wrote: > > Hi, > > I am new to Informix having spent most of my time looking after Oracle > systems. I currently have a problem/query which I hope you can resolve. > When doing an Oracle export a record of the tablespace that the > table/index was exported from is included as part of the export. > > I have been told that when doing an Informix dbexport there is no such > facility > ie. no record of which dbspace the table or index was exported from. > > Is this true ? If it is , then is there a fudge to get this info. out of > the database as part of the dbexport. If it is not true how do you do it > ? > > TIA > > Lee Robertson It depends on which Informix OnLine version that you are running. If you are running v7.x, you can add the -ss option to include dbspace location, extent sizing, and locking mode. Note that the -ss option will not work for tables that are fragmented. If you are running v5.x there are other options using some of the fine software developed by some of the more 'senior' developers in c.d.i. John Carlson WH Smith, Inc