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!

Sequences generated in DDL too late or not at all

pnoskoApr 27 2023

I'm using version 23.1. I created surrogate key columns using Auto Increment for a sequence (no trigger) and On Null default values for the sequence's NEXTVAL. If I generate DDL in a single file, the sequences are created after the tables are created, causing an ORA-02289: sequence does not exist error. If I generate DDL in separate files, the sequences are not created at all.

Added on Apr 27 2023

#data-modeler

3 comments

1,064 views