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.
A D V E R T I S E M E N T
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.
How to Increase the Tablespace free space?
Your tablespace PSAPBTABD is 92% used. How to increase the free space? SAPDBA V3.1I - SAP Database Administration ____________________________________________________________________________ ORACLE version : 7.3.4.3.0 ORACLE_SID : ALD ORACLE_HOME : /oracle/ALD DATABASE : open SAPR3 : 31H, 23 times connected a - Startup/Shutdown instance h - Backup database b - Instance information i - Backup archive logs c - Tablespace administration j - Check (and repair) database d - Reorganization k - Restore/Recovery e - Export/import l - Show/Cleanup f - Archive mode m - User and Security g - Additional functions n - Help q - Quit Please select ==> c ____________________________________________________________________________ Tablespace administration ____________________________________________________________________________ Current value a - Tablespace: b - Log checks: no c - Free space and fragmentation of all tablespaces d - Check free space of objects in all tablespaces e - Check free space of objects in tablespace f - Alter tablespace Add Datafile g - Create/drop tablespace h - Display all tablespaces and datafiles i - Display raw device drivers in /dev q - Return Please select ==> a Enter tablespace name [%] ==> psapbtabd ____________________________________________________________________________ Tablespace administration ____________________________________________________________________________ Current value a - Tablespace: PSAPBTABD b - Log checks: no c - Free space and fragmentation of all tablespaces d - Check free space of objects in all tablespaces e - Check free space of objects in tablespace PSAPBTABD f - Alter tablespace PSAPBTABD Add Datafile g - Drop tablespace PSAPBTABD h - Display all tablespaces and datafiles i - Display raw device drivers in /dev q - Return Please select ==> f ____________________________________________________________________________ Alter tablespace PSAPBTABD add datafile ____________________________________________________________________________ Current value a - File system or raw device: file system b - File size: 2088960 K (larger than free space) c - Select path: /oracle/ALD/sapdata5 d - Alter suggested path: /oracle/ALD/sapdata5 free space: 3608 K e - Display current files: 10 files, total (in DB): 77 s - Start (Add datafile) q - Return Please select ==> s