Archiving and Reorganization
are totally different issues
Archiving is a process
when you archive old master/transactional records which are not in use
any more from long time. You archive those records keep on some backup
device. These records can be displayed, and only Display, can never be
reloaded in tables again physically.
Reorganization basically
removes deleted data from tables. During different transactions you delete
some records, which are deleted virtually but not physically. Even Archive
process delete those records virtually.
This make the difference between the two clear. Now about reorganization. It depends on which OS and DB you are using. If Oracle, SAPDBA is best tool to reorganise. In addition to above, you can reorganise the whole database, but it takes time depending upon your database. Some times it can be more than a day or you can reorganise a table suggested in Early Watch system. It all depends on you.
Questions
Best regards,
All the site contents are Copyright © www.erpgreat.com
and the content authors. All rights reserved.
|