When creating a feature class in Oracle Spatial to store geometry, and using a DBTUNE keyword that includes the parameter GEOMETRY_STORAGE SDO_GEOMETRY, the following error will can occur:"Failed to create feature class. Operation failed [ORA-00902:invalid column name]"
When SDO_GEOMETRY is specified for GEOMETRY_STORAGE in SDE.DBTUNE, ArcSDE uses MDSYS.SDO_GEOMETRY to support the datatype. The error will occur if Oracle Spatial is not installed on the ArcSDE for Oracle server. It also occurs if Oracle 9i Locator is not installed on the Oracle server.
Confirm the support of MDSYS.SDO_GEOMETRY datatype by creating a table that uses it with SQL. Use the following as an example:
CREATE TABLE JUNK1 (
If this command fails with "ORA-00902: invalid datatype", then Oracle Spatial is not installed.
Get help from ArcGIS experts
Download the Esri Support App