See below.
a. Geodatabase ArcSDE Repository Version 10.7 is too old if you are using ArcGIS Pro 2.9.4
you must upgrade you Geodatabase Repository to 10.9.1.2.9 using ArcGIS Pro 2.9.4
Client and geodatabase compatibility—ArcGIS Pro | Documentation
Note:
Oracle Enterprise Geodatabase ArcSDE Repository Upgrade Using Oracle Restore Point
b. Spatial Index options for Grid 1, Grid 2, Grid 3 are now deprecated in ArcGIS Pro
https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/add-spatial-index.htm
in ArcMap / ArcCatalog - 10.8.1 these options are still valid though.
Add Spatial Index (Data Management)—ArcMap | Documentation (arcgis.com)
c. These were probably the reasons you received the error "db_stgeom_create_index::ORA-29855" when you tried to use ArcGIS Pro to copy and paste the featureclass from the FileGeodatabase into the Oracle Geodatabase.
Workarounds:
Option 1: upgrade the Oracle Enterprise Geodatabase Repository to 10.9.1.2.9 using ArcGIS Pro 2.9.4 then try the copy and paste again
Option 2: delete the spatial index in the FileGeodatabae Featureclass then try to copy and paste
Option 3: export FileGeodatabae Featureclass to XML document schema-only, then import XML into Oracle Geodatabase to recreate the Featureclass empty, then use Pro Append Data Tool to load the data from the FileGeodatabase Featureclass into the Oracle Featureclass, note to make the data load faster drop the Oracle Featureclass Spatial Index first, after the load is done the spatial index is recreated automatically.
Note: How Load Large Featureclass Oracle Geodatabase
Oracle Version Note:
Oracle 18c was deprecated by Oracle, 18c reached end of life and Oracle announced there will be no more Oracle Database 18c Patches. Oracle Database Customers need to move to 19c the new long term Oracle Release.
| Marcelo Marques | Principal Product Engineer | Esri |
| Cloud & Database Administrator | OCP - Oracle Certified Professional |
I work with Enterprise Geodatabases since 1997.
“ I do not fear computers. I fear the lack of them." Isaac Isimov