FAQ: What Are the Steps after Importing a Table with an ST

Answer

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.

Code:
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.

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

Article ID:000009850

Software:

Legacy Products

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

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

Answer

Discover more on this topic