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

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

RedaAli — Mon, 24 Jul 2023 12:08:28 GMT

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?

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

MarceloMarques — Mon, 24 Jul 2023 14:52:24 GMT

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.

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

RedaAli — Tue, 25 Jul 2023 07:08:10 GMT

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

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

ChrisUnderwood — Tue, 25 Jul 2023 07:40:23 GMT

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

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

RedaAli — Wed, 26 Jul 2023 09:44:34 GMT

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?

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

MarceloMarques — Tue, 25 Jul 2023 14:56:30 GMT

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