Is This Content Helpful?
We're glad to know this article was helpful.
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"
Max Extents in the SDE.GDB_USERMETADATA table is too small; the default value is 200.
Check the Oracle Alert Log for additional information.
Increase the Max Extents in the SDE.GDB_USERMETADATA table; for example: 1024.