Symptom
- Creating a table using the 'with compression' or 'lob_compression' parameters may fail with the following error
1> create table test_comp (t1 int) with compression = row
2> go
Msg 2799, Level 16, State 1:
Server 'ase2k', Line 1:
'CREATE TABLE' command failed because 'COMPRESSION' is not enabled. A user with
System Administrator (SA) role must reconfigure 'enable compression' to 1.
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) version 15.7 and later
- All OS platforms
Product
SAP Adaptive Server Enterprise 15.7
Keywords
compression, lob, create table , 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 ONE Support launchpad (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.