Hi,
I've found a few topics in this community on the new 12c IDENTITY feature for a column, but none that seems to address my concern. Is there a way to change the CACHE option for an IDENTITY column? The DDL generated after you declare the column as identity looks like this:
CREATE TABLE MY_TABLE
(
ID INTEGER GENERATED BY DEFAULT AS IDENTITY
( START WITH 1 **NOCACHE** ORDER ) NOT NULL ,
DESCRIPTION VARCHAR2 (50 CHAR)
)
LOGGING
;
In the Physical Model, I see only this:

So where can I change the CACHE value, especially because the default value is supposed to be 20, but should even be increased according to Oracle's recommendation:
https://docs.oracle.com/database/121/SQLRF/statements_7002.htm#CJAIJGEG
I'm using Data Modeler 4.1.5.
Thanks