Depending on the size of the table, the reorganization operation might take a long time. The status page of the Table Reorganization wizard shows you the progress of the reorganization operation and allows to break the reorganization operation. You can see the the currently executed step and all previously executed script commands in the log panel located in the middle of the page.
If an error occurs during the reorganization operation, three panels appear in this wizard page.
The top panel displays the exact error message as was generated by database server or telnet command. For example, it could be a SQL error, which resulted from an attempt to recover table's user permission.
The middle panel shows the status of the reorganization when the error occur. Some errors can be fixed from outside of the wizard or by returning to the previous wizard pages and modifying wizard parameters. The reorganization operation is resumed from the last successfully completed step. For example,
The operation is resumed from the step 2) - dropping and recreating the table - so that the state of the table data is properly preserved.
The bottom panel displays the log of all operations performed during the execution of the reorganization script.
Press the Back button to return to the previous pages and retry the operation. You can also change some parameters before you retry the operation.
Press the Abort button to break the operation. When you break the operation the status panel and the log panel shows you the steps, which were performed up to the moment of the operation interruption. You can resume the interrupted operation by pressing the Back button to return to the previous page and pressing the Start button in it.
Press the Finish button after the operation is successfully executed to see the table data allocation statistics before and after the reorganization operation.