SAP Knowledge Base Article - Preview

2529293 - Error ORA-00907 - Wrong script generated with "identity" column - SAP PD

Symptom

  • PowerDesigner is generating a script that is not correct and when using this script to create a table in Oracle 12c, it reports the error below:

----
#Error in line : 2 in command -
create table SUDIS_INV_AMBIENTE (
ID_AMBIENTE NUMBER not null generated always as identity ( start with 1
increment by 1 nocycle order),
NME_AMBIENTE VARCHAR2(100) not null
)
tablespace SUDIS_TS

Error report -
ORA-00907: missing right parenthesis
00907. 00000 - "missing right parenthesis"#
----

  • The correct script should be:

----
ID_AMBIENTE NUMBER generated always as identity ( start with 1
increment by 1 nocycle order) NOT NULL,
NME_AMBIENTE VARCHAR2(100) not null
)
tablespace SUDIS_TS;#
----


Read more...

Environment

SAP PowerDesigner (PD) 16.6

Product

SAP PowerDesigner 16.6

Keywords

Wrong script, identity, power designer, CR810536 , 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.