Shrink DB

#1

Hi there

I divided a db into two pieces and deleted all transfered record in the
original db, but the db didn't shrink
I think that's ok in the normal case, but I WANT to clear this memory after
deletion.
How to?

DB size: 1.03 GB
Records transfered/deleted: 500 MB
db after: 1.03 instead of 1.03 GB - 500 MB

Ravage

#2

"Ravage" <ravage (AT) bluewin (DOT) ch> wrote

Quote:

I divided a db into two pieces and deleted all transfered record in the
original db, but the db didn't shrink
I think that's ok in the normal case, but I WANT to clear this memory after
deletion.
How to?

Do an unload/reload.

Dmitri.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Shrink DB

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general

Shrink DB - 12-11-2003 , 02:12 AM

Re: Shrink DB - 12-11-2003 , 02:48 AM