copydbf - Copy a database file

SYNOPSIS

copydbf oldfile newfile

DESCRIPTION
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.