FAQ: Why does table registration fail when using the ArcSDE sdelayer -o command?


Why does table registration fail when using the ArcSDE sdelayer -o command?


The following are some of the reasons why a table fails to register with ArcSDE:

· The -t option was not specified: Beginning with ArcGIS 9.3, the -t option must be specified when registering a spatial table with ArcSDE using the sdelayer command.

The command syntax returned when sdelayer -h is typed indicates the -t option is optional. This is incorrect.

· The geometry storage type specified with the -t option does not match what is in the table: Make sure to specify the correct geometry type with the -t option when registering the table.

· The table contains multiple spatial columns: The table being registered can only contain one spatial column. If the table contains multiple spatial columns, create a view of the table that contains only one spatial column, then register the view with ArcSDE.

· The spatial reference ID (SRID) specified with the -R option does not exist in the SPATIAL_REFERENCES table or is not correct for the table being registered.

· The table contains records of different subtypes. For example, it contains some ST_POINT records and some ST_POLYGON records: To register with ArcSDE, the table can only contain one type of geometry.

· The table contains multiple columns of a user-defined type. For example, the table contains an SDO_GEOMETRY column and an SDO_GEORASTER column: Tables registered with ArcSDE can contain only one column that is a user-defined type.

· The user attempting to register the table with ArcSDE is not the owner of the table: Only the owner of the table can register it with ArcSDE, so be sure to provide the user name and password of the owner with the -u and -p options respectively.

· Different records in the table are registered with different SRIDs: All data in the table must use the same SRID to be able to register it with ArcSDE.

· The name of the table is invalid: The table name cannot begin with a number or be in mixed case. Also, the table name cannot exceed 128 characters (or 30 characters if registering in an Oracle database).

Related Information