Re: DBExport

Use dbexport -ss -d <DATABASE> This will give you the table fragmentation and DBspaces used. The exceptions are tables and indices that are created in the default DBSpace. The default is the DBSpace in which the database was created. Use onmonitor - STATUS - DATABASES to find the default DBSpace for the database. -d At 01:47 PM 8/21/97 +0100, 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 } }