SAP Knowledge Base Article - Preview

2569154 - Can neither generate nor reverse the table attribute CLUSTERING for Oracle 12 - SAP PD

Symptom

  • Attribute clustering is a new feature that comes with Oracle 12.1.0.2.
  • SAP PD currently does not allow to generate or reverse this table property with linear or interleaved ordering.
  • There is no Clustering in linear/interleaved order available in table's Physical options.
  • The SQL syntax is:

CREATE TABLE table (columns)
CLUSTERING BY LINEAR/INTERLEAVED ORDER (columns)
WITHOUT MATERIALIZED ZONEMAP;

or

ALTER TABLE table
ADD CLUSTERING BY LINEAR/INTERLEAVED ORDER (columns)
WITHOUT MATERIALIZED ZONEMAP;


Read more...

Environment

  • SAP PowerDesigner (PD) 16.6
  • Oracle Version 12c

Product

SAP PowerDesigner 16.6

Keywords

XDB, 812033, CR812033, CR#812033 , KBA , BC-SYB-PD , PowerDesigner , Bug Filed

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.