Re: Reducing Table Sizes

Herb, It will work fine. As long as the number of rows in the SQL file is the same as the number of rows in the unload file you wont get an error. Regards David Ashby ______________________________ Reply Separator _________________________________ Subject: Reducing Table Sizes Author: Herb Blacker <herbb@jcdcrs4.jcdcnet.org> at WCA-INET Date: 15/6/98 2:08 PM 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 -----------------------------------------------