Oracle Lite Database

[Jeff Odell]

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

[Jeff Odell]

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.