ERROR
While trying to Copy, Paste or Import existing data as ST_GEOMETRY, one of the following errors is displayed:
Failed to Paste <FEATURE> Underlying DBMS error[Error executing PL/SQL Block db_stgeom_create_index::ORA-29855: error occured in the execution of ODCIINDEXCREATE routine ORA-20083: Parameter ST_SRID <SOME NUMBER> does not exist in ST_SPATIAL_REFERENCES table.] DBMS table not found[<further error info removed>]or
Failed to Paste <FEATURE> Underlying DBMS error[Error executing stored procedure <schema>.spref_util.insert_spatial_ref::ORA-01400: cannot insert NULL into ("SDE"."ST_SPATIAL_REFERENCES"."SR_NAME")] DBMS table not found[<further error info removed>]
Previous versions of ArcObjects allowed a Spatial Reference to be defined without supplying a name. This created the Spatial Reference with a NULL name.
For example, it is possible to create a feature with a spatial reference (projection) that consists of a string that contains:
GEOGCS["",DATUM["",SPHEROID["",1.0,0.0]],PRIMEM["",0.0],UNIT["",1.0]]
The ST_GEOMETRY type is OGC-compliant and requires that the feature have a Spatial Reference with a name.
Re-create the spatial reference by using ArcCatalog.
Get help from ArcGIS experts
Download the Esri Support App