Question

删除client后如何回收空间

系统内某client删除后，如何回收空间，使使用率降低。 DB2数据库有个叫HWM HIGH WATER MARKS 可以通过db2dart来reduce 不知道oracle是否有相关的方法。

Answer 1

我这里有个情况: 环境HP-UX,46D,oracle8. 测试系统有个client垃圾数据非常多,想清理掉. head告诉我,把client deleted后做reorg. 我提出,应该先做archive后再delete,再reorg. head说没时间,没人做archive. 结果我又去咨询了才给我们做了PRD reorg的顾问,顾问说,delete client等于archive. 然后我就操作了: 1.client deleted 2.reorg 结果,非常不好,reorg时完全不能释放空间!!!!!!!!!!!!

Answer 2

对MSSQL下的client delete： SAP给的的建议： 1. log on the client which you want to delete 2. go to transaction SCC5 3. Start the deletion of the client,better using background processing After deleting the client if the space occupied by tables is not changed when deleting data we could also refer to reorgnize the database for release the space.We could also refer to the info in the note 159316 for more info about this problem: 在Note ?159316 中建议参考这一个微软的技术文档： http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx

Answer 3

是的，我也很想知道，请高手指点。 我们的平台：windows 2000 MSSQL2000 最近我复制了一个测试client，用完后想删除，并释放空间，查了些资料都是oracle下面的，不 知 mssql下面有没有人做过