copydbf - Copy a database file


copydbf oldfile newfile

The copydbf program can be used to copy tables while compressing any space in the file due to deleted records. The new file must have a different name than the old file. It performs a similar job to CREATE TABLE ...AS SELECT ...except that with copydbf the new table is not registered in the database.

If you want to replace a table with a compressed version of the table you will need to drop all indexes on the table, and recreate them after replacing the file. This is because records may have moved to fill in the gaps in the table.

Copyright © Thunderstone Software     Last updated: May 19 2023
Copyright © 2023 Thunderstone Software LLC. All rights reserved.