SAP Knowledge Base Article - Preview

3351573 - Reorg command returns Msg 102 "Incorrect syntax near..." when running from isql - SAP ASE for Business Suite and Business Warehouse


  • You want to execute manually a reorg on a table with "/" character in name, and error Msg 102 is returned, ie:

            1> reorg reclaim_space '/BI0/XXXX'
            2> go
            Msg 102, Level 15, State 181:
            Server 'SLQ', Line 2:
            Incorrect syntax near 'reclaim_space'.

  • Note that reorgs are executed/scheduled from DBACockpit by ATM and can also be scheduled specifically for a table running from menu Space > Tables and Indexes > Single Table Analysis > Enter the table_name and click on "Apply Selection", you'll see the button "Reorganization" on top menu.



SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite


SAP Adaptive Server Enterprise 16.0


KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.