I created a physical ERD -Model for my tables and use the update database mode to generate create and alter table ddls for oracle, which workes fine.
Now I started to modell sequences for my primary keys and triggers with a scripts to initialize my primary keys with the next sequence number.
Problems are:
- Even though I am still using the update database mode, the ddl-Statment for the sequences is always an alter instead of an create statement no matter if the sequence does or does not already exist.
Example:
ALTER SEQUENCE d2po_sharedKernel.seq_item INCREMENT BY 1 MAXVALUE 999999999999999999 MINVALUE 1 NOCYCLE CACHE NOORDER;
- Even if I replace the alter with create the statement can not be executed by oracle
create SEQUENCE d2po_sharedKernel.seq_item INCREMENT BY 1 MAXVALUE 999999999999999999 MINVALUE 1 NOCYCLE CACHE NOORDER;
ORA -01722
I have the edit the statement furthermore to
create SEQUENCE d2po_sharedKernel.seq_item INCREMENT BY 1 MAXVALUE 999999999999999999 MINVALUE 1 NOCYCLE noCACHE NOORDER;
Is there anything I can do to end up with correct create statements?