English

Error: DBMS table not found [ORA- 00942 : table or view does not exist]

Error Message

When creating a new ST_Geometry layer in Oracle, the following error message displays:

"DBMS table not found [ORA-00942: table or view does not exist]"

An error in the ArcSDE error log displays the following error message:

"S_enable_spatial_type_column::Error adding column(955)"

Cause

One cause of the problem is the ArcSDE DBTUNE parameter st_geom_lob_storage specifically defines a LOB segment name. Oracle's LOB segment name must be unique per schema. Therefore, if the DBTUNE st_geom_lob_storage parameter is not updated each time to store the LOB segment using a unique name, the second attempt to create a new ST_Geometry layer fails and the following error message displays:

"DBMS table not found [ORA-00942: table or view does not exist]"

For example, the following st_geom_lob_storage parameter value causes the error to occur, because each time the Oracle LOB segment is created it attempts to name the LOB segment 'st_lob_segment'.

STORE AS st_lob_segment (ENABLE STORAGE IN ROW CHUNK 8K RETENTION CACHE)

Solution or Workaround

To avoid the error, do not set a LOB segment name in the storage string for the st_geom_lob_storage parameter.

If the name is not specified, Oracle internally generates a unique name.

To update the ArcSDE DBTUNE parameters use the sdedbtune command.

Note:
See the ArcGIS Documentation Library link in Related Information for additional information on the sdedbtune command.

Below is an example of a valid st_geom_lob_storage storage clause:

STORE AS (ENABLE STORAGE IN ROW CHUNK 8K RETENTION CACHE)

    Related Information