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
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.