Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: Jeff Odell on February 16, 2005, 11:33:43 am

Title: Oracle Lite Database
Post by: Jeff Odell on February 16, 2005, 11:33:43 am

Has anyone implemented the types for Oracle Lite 10g?  I need to do some data modeling for that platform.  If not, I'll tackle it myself and learn a few things.

Thanks in advance -

Jeff odell

Title: Re: Oracle Lite Database
Post by: Jeff Odell on February 18, 2005, 10:28:19 am

As a self follow up, it turns out the types in Oracle Lite are roughly compatible with the types in regular Oracle Server.  You can get a long way generating DDL using the Oracle settings.

The only problem to date is when you set the Autonumber property for a column.  Sequence generated command is:

CREATE SEQUENCE APPLICATION_GROUP_ID_SEQ
increment by 1
start with 1
NOMAXVALUE
minvalue 1
nocycle
nocache
noorder;

Oracle Lite doesn't like the nocycle, nocache or the noorder.  I'm posting a separate post to see if anyone knows how to suppress this.