Reducing Table Sizes
Posted in 1998
Herb Blacker — — source: Informix-list mailing list archive (1991-1998)
Here's a thought...I wish to copy a database to a *test* instance, but I don't need the tables to be as large as those in the production DB. What I was thinking...and I could be way off base here...is that if I did a DBEXPORT, then edited the <dbname>.sql file to reduce the number of rows where the table is being created, and *also* edited the corresponding <tabname>.unl file to remove all but the # of rows I want to import - will the DBIMPORT work or not? ----------------------------------------------- Herb Blacker Cimarron, Inc. Sr. Database Administrator Dept. of Labor Job Corps, San Marcos, Texas -----------------------------------------------