English

Error: dbms table not found, [SDE.SDB_fcconn] state id =0 ora- 00942 : table or view does not exist

Error Message

This error occurs while importing data and while also loading metadata from a shapefile or Personal Geodatabase into an ArcSDE for Oracle Geodatabase.

"dbms table not found, [SDE.SDB_fcconn] state id =0 ora-00942: table or view does not exist"

Cause

Max Extents in the SDE.GDB_USERMETADATA table is too small; the default value is 200.

Note:
Check the Oracle Alert Log for additional information.

Solution or Workaround

Increase the Max Extents in the SDE.GDB_USERMETADATA table; for example: 1024.