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?
Solved! Go to 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.
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
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.
Hello Marcelo,
When I opened the database connection from ArcMap v10.7.1, the issue resolved for all layers.
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.
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
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?
@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
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...