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?

[MarceloMarques]

Please, open a ticket with Esri Technical Support to investigate this further. 
There are many reasons this can happen, including invalid geometries or a bad spatial index.

[RedaAli]

Hello Marcelo,
When I opened the database connection from ArcMap v10.7.1, the issue resolved for all layers.

[ChrisUnderwood · Accepted solution]

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 ...

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 | Docu...

[RedaAli]

Thanks for your clarifications @ChrisUnderwood  , it might be an issue with computability of ArcGIS Pro v3.1.2 with oracle 11.2.0.4.

Could you please send the arcgispro v3.1.2 compatibility with Oracle DB versions list?

[MarceloMarques]

@RedaAli - Could you please send the arcgispro v3.1.2 compatibility with Oracle DB versions list?

Answer: Chris Undeerwood's reply has the link to the system requirements page.

ArcGIS Pro 3.1.x - 3.1.0, 3.1.1, 3.1.2

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

ArcMap 10.7.x / Pro 2.3.x, 2.4.x
Oracle database requirements for ArcGIS 10.7.x and ArcGIS Pro 2.3 and 2.4—System Requirements | Docu...