0

In ArcGIS Desktop, I can register ST_Geometry objects with the geodatabase (Enterprise 10.7.1; Oracle 18c):

Register with Geodatabase

Register feature classes, tables, views, and raster layers that were created in the database using ArcGIS clients with the geodatabase. Once registered, information about the items—such as table and column names, spatial extent, and geometry type—is stored in the geodatabase's system tables, allowing these registered items to participate in geodatabase functionality.


It would be helpful to know what happens when I register an object with the geodatabase — for troubleshooting purposes.

  • For example: Occasionally, GDB objects become orphaned; the database object has been deleted, but the geodatabase system records still persist (an artifact of the object shows up in ArcCatalog that can't be deleted via ArcCatalog).

It's my understanding that the action of registering an object with the geodatabase INSERTS records into system tables.

Question:

What system tables get the INSERTS?

  • TABLE_REGISTRY
  • ST_GEOMETRY_COLUMNS
  • Other?

Note: my feature classes have domains, but not relationship classes.

2
2

GDB_ITEMS, TABLE_REGISTRY, LAYERS, COLUMN_REGISTRY, GEOMETRY_COLUMNS, ST_GEOMETRY_COLUMNS (if using ST_GEOMETRY storage type)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.