ArcGIS Server Banner

Oracle data types

Oracle data types
Release 9.3 E-mail This TopicPrintable VersionGive Us feedback
Note:This topic was updated for 9.3.1.

When you create a feature class or table in ArcGIS, there are 11 different data types available for each column. These types are mapped to Oracle types in the following table:


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.

* ST_Geometry is a superclass. The actual data subtype created (such as ST_Multilinestring or ST_Point) depends on what type of feature class you create, whether polygon, line, point, multipoint, or multipatch.

See Also

  • About data types
  • About geometry storage types