copydbf oldfile newfile
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
copydbf the new table is not registered in the
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.