I have some db files which have grown over time and are, after deleting
data, too big.

Is it possible to 'release' the free space and make the file smaller?

If not, what is the easies way to do that?

Thanks,

marcel

"Marcel" <marcel (AT) it2be (DOT) nl> wrote:

The only way to accomplish that is to unload and reload a database.

Dmitri.

use "rebuild" command

Prabir

"Marcel" <marcel (AT) it2be (DOT) nl> wrote

Prabir C wrote:
I believe you are referring to the "rebuild" script ("rebuild.bat" on
MS-Windows) which is simply a shell-script wrapper around the dbunload
tool. Alternatively, you can use the Unload Database wizard in Sybase
Central.

Hope this helps,
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/