Skip to Main Content

SQL Developer Data Modeler

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Change the CACHE option in the IDENTITY clause for a column

GregVFeb 2 2017 — edited Feb 3 2017

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:

pastedImage_0.png

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

This post has been answered by Heli on Feb 2 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 3 2017
Added on Feb 2 2017
5 comments
3,172 views