How do I Reorg/compact a Sybase DB
Posted on 1999-01-20
Using AIX, Sybase SQL server and Open Client/Server 10.0.2
Lots of Memory/HD space
In a sybase DB, when items are deleted, the data is simply flagged as not used. In MSAccess, you can get rid of this excess data by "compacting" the DB. This removes all the flagged data and leaves only the active items in the DB. My question is: How do I do this for a Sybase DB. I have heard about using a function called reorg, but I can't find anything like that anywhere, not even in the manuals, online documentation, or SyBooks.
Please give the specific commands that must be run in order to "compact" the DB. And if possible, commands that can be run in a script.