We have 3 database spaces: central.db, sales.db, invoice.db. The invoice.db has grown quite large and we are looking to drop 50% of the records (90GB of data). Is it possible to rebuild just this database space to reclaim this disk space or will we have to do a full unload/reload of the entire database?
We are using SQL Anywhere v12..01.3942 on Windows Server 2008 R2.
asked 15 Apr '14, 09:56
You might suggest an enhancement to "move" a table to another dbspace, something like the fictional
Apparently, that would be an expensive operation, even more than REORGANIZE TABLE...
That way, you could move a table to a new dbspace and drop the old one afterwards - or could move it "home" to the system dbspace. Like REORGANIZE TABLE, it should not have effect on replication/synchronization as it would just move data physically, but not logically.