ArcGIS data type |
Oracle data type |
Notes |
OBJECTID |
NUMBER(38) |
NOT NULL |
SHORT INTEGER |
NUMBER(4) |
|
LONG INTEGER |
NUMBER(38) |
|
FLOAT |
NUMBER(38,8) |
|
DOUBLE |
NUMBER(38,8) |
|
TEXT |
NVARCHAR2 or VARCHAR2 |
This field will be NVARCHAR2 in the database only if your geodatabase is using Unicode storage; otherwise, VARCHAR2 is used. |
DATE |
DATE |
|
BLOB |
BLOB |
|
GUID |
CHAR(38) |
|
GEOMETRY |
ST_GEOMETRY*
NUMBER(38)
SDO_GEOMETRY |
Oracle data type depends on the geometry storage specified for the layer. |
RASTER |
BLOB
LONG RAW
SDO_GEORASTER |
Oracle data type depends on the raster storage specified in the DBTUNE table. |