Oracle 11g data types are not listed within EA.

[ssantiago]

When doing data modeling for an Oracle DB, I don't see all the Oracle 11g data types.  Do I have to manually define these if they are missing?  Here are the data types defined in 11g - not all are shown in EA:

http://download.oracle.com/docs/cd/E18283_01/appdev.112/e10646/oci03typ.htm#insertedID2

In particular, the BINARY_DOUBLE, BINARY_FLOAT, and TIMESTAMP data types.

In the Resources section of the Additional Downloads site I saw additional data type files for Access and SQL Server 2008/2005, but not for 11g.  Are these available anywhere?

Thanks,

Sam

[Eve]

What build are you using? The release notes say that interval and timestamp were added in build 858.

However, if your model was created before then, you may need to export the datatypes from the base model because they won't exist in your current model.

[ssantiago]

Yes, I am using build 858 - Program Version 8.0.858 (Build:858) - Unicode.  I created a new project as a test, but don't see any of the new Oracle data types:
http://www.softitechture.com/EA-oracle-types.png