• Reorganizing a Single Table with SAPDBA using method Reorganize Table by 'insert into select from …' or Reorganize Table by 'Export/Import'.
• Reorganizing a Group of Tables with SAPDBA
• Reorganizing a Dbspace and Its Tables with SAPDBA

1. Put the database server back into unbuffered logging mode to run the R/3 System. Refer to Switching to "Unbuffered Logging Mode" with SAPDBA.
2. Create a level-0 (full) database backup ( ON-Bar ) or archive ( ON-Archive or ontape ). For more information, see:

• Creation of a Database Backup (ON-Bar)
• Creation of an Archive (ON-Archive)
• Creation of an Archive (ontape)

3. If you have moved the table or tables to a new dbspace during the reorganization, then you need to:

1. Keep the information on the new dbspace for the next R/3 System upgrade. SAPDBA displays a message telling you of this. The information is held in the ABAP data dictionary of the R/3 System. Refer to Maintaining Technical Settings.
2. Enter a transport request using transaction SE13. Otherwise, the next R/3 upgrade erases the information about the new dbspace from the data dictionary. For more information about setting up a transport request, see BC - Change and Transport Organizer.

4. From time to time, clear up the $INFORMIXDIR/sapreorg (UNIX) or %INFORMIXDIR%\sapreorg (NT) directory in which SAPDBA creates working directories and files. Refer to SAPDBA Housekeeping.

You have now finished the reorganization. If you want to make sure that the reorganization has finished successfully, you can check the SAPDBA reorganization log.