English

FAQ: Is the '-x' option needed when creating or registering Oracle Spatial data using ArcSDE tools?

Question

Is the '-x' option needed when creating or registering Oracle Spatial data using ArcSDE tools?

Answer

sdelayer

The -x option is needed with the commands 'sdelayer -o add' and 'sdelayer -o register' to add an SDO_GEOMETRY spatial column to an existing table or register an existing table containing an SDO_GEOMETRY column as an ArcSDE feature class.

If the -x option is omitted from 'sdelayer -o add', the layer is created with default offset values of 0 and default scale values of 1. These default values cannot be changed and are probably not suitable for the data.

When registering a third party Oracle Spatial table with the 'sdelayer –o register' command, the values accompanying the -x option values are ignored, but the presence of the -x option signals ArcSDE to set correct offset and scale values, based on the metadata values in USER_SDO_GEOM_METADATA.

The problem of values being ignored has been fixed in ArcSDE 9.1

shp2sde and cov2sde

When creating a new feature classes with the shp2sde or cov2sde command without the –x, -z or –m options, the command calculates the correct x, y, z, and m offset and scale values and places them in the ArcSDE and Oracle Spatial metadata in USER_SDO_GEOM_METADATA.