SAP Knowledge Base Article - Preview

3216743 - Error when shrinking database using ALTER DATABASE with CHECK_ONLY option - SAP ASE


  • Running "alter database <db name> off  <device name> with check_only" produces the following message:
    ALTER DATABASE: segment '21' (ID 21) in database '<db name>' does not have enough free space to receive data that must be moved.
  • Running "alter database <db name> off <device name>" works without issue.



SAP Adaptive Server Enterprise (ASE) 16.0


SAP Adaptive Server Enterprise 16.0


CR#826771, CR826771, 826771, shrink, 5093 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.