SAP Knowledge Base Article - Preview

2611996 - Cannot specify an index name when using the USING INDEX clause - SAP PD

Symptom

  • The name of an index associated with a constraint cannot be specified when using the USING INDEX clause in an Oracle Physical Data Model (PDM).
  • This occurs when the target DBMS is either ORACLE Version 11g or ORACLE Version 12c.
  • It works fine with the ORACLE Version 10g or ORACLE Version 10gR2 DBMS resource files.
  • Example:

ALTER TABLE table_name ADD CONSTRAINT constraint_name PRIMARY KEY (column_name) USING INDEX index_name;


Read more...

Environment

  • SAP PowerDesigner (PD) 16.6
  • ORACLE Version 11g, 12c

Product

SAP PowerDesigner 16.6

Keywords

key, pk, primary, alternate, type, enter, reverse, re, 813768, CR813768, CR#813768 , 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.