Re: Export/Import Database - Help??

Peter Wiley - Poultry (peter@prospect.anprod.csiro.au) wrote: : Assuming you have Informix >=4.00 release, then : dbexport <your-database-name> : will create a subdirectory calles <dbname>.exp and write the complete SQL : script necessary to recreate the schema and dumps all the data to ASCII : files. Works great. dbimport rebuilds the database. Peter is correct. However, there is one problem which can lead to serious problems for large tables in Online: Extent information is not preserved, so the default extent sizes (16k) are chosen. If you have larger tables than that in Online (who doesn't?), you must manually edit the schema (file <dbname>.sql in directory <dbname>.exp) to add the extent sizes you need. Hope that helps, Richard -- +----------------------------+-------------------------------------------+ | Dr. Richard Spitz | INTERNET: spitz@ana.med.uni-muenchen.de | | EDV-Gruppe Anaesthesie | Tel : +49-89-7095-3421 | | Klinikum Grosshadern | FAX : +49-89-7095-8886 | | 81366 Munich, Germany | | +----------------------------+-------------------------------------------+