SAP Knowledge Base Article - Preview

3209976 - SQL Anywhere Error -1250: Table 'YYYYYY' is not a partitioned table - SAP IQ

Symptom

Trying to add partition to an existing non partitioned table which has already data but hitting in the following error:

======

1> alter table dba.range_test add partition by range( col1 ) ( p1 values <= ( 10 ) in iq_main );
2> go
Msg 13264, Level 16, State 0:
SQL Anywhere Error -1250: Table 'range_test' is not a partitioned table

======


Read more...

Environment

SAP IQ 16.1

Product

SAP IQ 16.1

Keywords

partition table partitioned non-partitioned alter table by range 13264 SQL Anywhere Error -1250: Table  is not a partitioned table existing , KBA , BC-SYB-IQ , Sybase IQ , 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.