Frequently asked question

What are the steps after importing a table with an ST_Geometry attribute in Oracle?

Last Published: April 25, 2020


After performing an Oracle import operation, the table or tables containing the ST_Geometry attribute are registered with the ST_Geometry metadata table, sde.st_geometry_columns.

However, the table is not registered with ArcSDE and cannot be accessed with ArcGIS.

To register the table with ArcSDE to allow it to be accessible by ArcGIS, one must use the sdelayer -o register command.

C:\> sdelayer -o register -l buildings,shape -e nac+ -u tb -p tb -i esri_sde

When executing the command, there is no need to specify the -R argument for the spatial reference identifier. The registration command detects the SRID value from the ST_Geometry attribute and validates the spatial_reference is present in the sde.spatial_references table. If this does not occur, the spatial reference is created by using the table's spatial reference from the sde.st_spatial_reference table.

For additional information on the sdelayer command, see the ArcSDE documentation.

Article ID:000009850

  • Legacy Products

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options