| Reorganization of Single Object
You have ARCHIVED the BSIS table (because of old data
etc) and now this BSIS table has "holes" in physical structure and it's
quite a large table.
Here are the steps to reorg. a single object:
1. Take a backup of your Oracle database.
2. Shutdown SAP
3. Start Oracle Database with Rollback Segment PSAPROLLBIG
(all other smaller segments not started). Remember, the size of PSAPROLLBIG
should be equal or larger than your BSIS table.
4. Ensure sapreorg directory has enough space for taking
BSIS Oracle Export dump. The Oracle Export utility compresses the file
to some extent.
5. Fire your SAPDBA from Unix level.
6. Go into SAPDBA "reorganisation" menu.
7. Select "Reorganize Single Table / Index"
8. Give BSIS as table name.
9. Start.
10. Don't Forget, first upgrade your SAPDBA tools first
from OSS/SAPNet.
These include: 1. sapdba 2. brtools 3. brarchive 4. brbackup
5. brrestore 6. brconnect.
Questions
Do you have
a SAP Basis Question?
Best regards,
SAP Basis, ABAP Programming and Other IMG Stuff
http://www.erpgreat.com
All the site contents are Copyright © www.erpgreat.com
and the content authors. All rights reserved.
All product names are trademarks of their respective
companies. The site www.erpgreat.com is in no way affiliated with
SAP AG.
Every effort is made to ensure the content integrity.
Information used on this site is at your own risk.
The content on this site may not be reproduced
or redistributed without the express written permission of
www.erpgreat.com or the content authors.
|