shrinking a .tbl file in Windows NT

Post Reply
Mr. Bigglesworth
Posts: 56
Joined: Fri Feb 16, 2001 6:54 pm

shrinking a .tbl file in Windows NT

Post by Mr. Bigglesworth »

We've got a table whose size is close to the 2 GB file limit.

Over time, we've deleted certain records from this table, but the .tbl size hasn't shrunk-- in fact, it's grown a little. Is there a way we can compress the file a bit, without having to drop and recreate the table? Thanks.
User avatar
mark
Site Admin
Posts: 5519
Joined: Tue Apr 25, 2000 6:56 pm

shrinking a .tbl file in Windows NT

Post by mark »

You'll have to use copydbf to compact it. Make sure the table is not being modified while it's being copydbf'd. Then you'll have to recreate all of the indices for the compacted table.
bart
Posts: 251
Joined: Wed Apr 26, 2000 12:42 am

shrinking a .tbl file in Windows NT

Post by bart »

You may also wish to move some of the larger fields out to blob datatypes while you're in the process.
Post Reply