After Restore SDE,Owner schema ERROR:invalid Table/column in SDO_GEOM_METADATA table [invalid table/column in SDO_GEOM_METADATA table]

RedaAli

Hi, 

 Environment: Oracle 11g R2 

 Enterprise geodatabase version: 10.7.1 with SDO (Spatial Data Object configuration for storage)

Scenario:

 Restoring SDE, Owner Schemas done using impdp from dmp files of the Schemas

 When opening feature class attribute table on Arcgis Pro v3.1.2

an error occured "invalid Table/column in SDO_GEOM_METADATA table [invalid table/column in SDO_GEOM_METADATA table] "

 

Please advice if there is any required change needed on MDSYS tables and what is it?

ChrisUnderwood

Hello @RedaAli as your restored Geodatabase does appear to function with ArcMAP 10.7.1, then that suggests the restore may have completed correctly. But unfortunately Oracle 11g R2 is too old for use with ArcGIS Pro 3.1.2 and so is not a supported option.

ArcGIS 11.1 and ArcGIS Pro 3.1 requirements for Oracle—ArcGIS Enterprise | Documentation for ArcGIS Enterprise

If you want to access your Geodatabase from both ArcGIS Pro 3.1.2 and ArcMAP 10.7.1 then you need to use Oracle 19c

Oracle database requirements for ArcGIS 10.7.x and ArcGIS Pro 2.3 and 2.4—System Requirements | Documentation