Main Menu

Banner
Banner

ERPGenie Websites

ERP Software Corner

Attention: open in a new window. PDFPrintE-mail

2010
07
Mar

Reorganization of Single Object

Written by SAP Basis

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. 1. Take a backup of your Oracle database.
  2. 2. Shutdown SAP
  3. 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. 4. Ensure sapreorg directory has enough space for taking BSIS Oracle Export dump. The Oracle Export utility compresses the file to some extent.
  5. 5. Fire your SAPDBA from Unix level.
  6. 6. Go into SAPDBA "reorganisation" menu.
  7. 7. Select "Reorganize Single Table / Index"
  8. 8. Give BSIS as table name.
  9. 9. Start.
  10. 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.
Last Updated (Tuesday, 30 November 1999 00:00)
Free software downloads

©2001-2011 Genieholdings.COM, Inc. All rights reserved. ERPGenie.COM, EDIGenie.COM, myPIgenie.COMand ESAGenie.COM are Trademarks of Genieholdings.COM, Inc. All product names are trademarks of their respective companies. GenieHoldings.COM, Inc. and it's websites are in no way affiliated with SAP AG. SAP, SAP R/3, R/3 software, mySAP, ABAP, BAPI, xApps, SAP NetWeaver, and and any other SAP trademarks are registered trademarks of SAP AG in Germany and in several other countries. Every effort is made to ensure content integrity. Use information on this site at your own risk.