You can try this to find the geometries that fail to load.
1. Open ArcCatalog
2. connect to the SDE geodatabase
3. right click the featureclass > Export > XML Workspace Document > Schema Only
4. create a FGDB
5. right click the FGDB > Import > XML Workspace Document
6. import the xml schema only file for the featureclass
7. select the FGDB featureclass > right click > Load > load data... ( this is the Simple Data Loader Tool )
Input data will be your SDE featureclass
the Simple Data Loader might show you the records that fail to load.
In Pro you can use the same steps, but there is no "Simple Data Load Tool" and you can use the GP Tool "Append Data".
Other Options to Validate your Featureclass Geometries.
1. Geodatabase TOPOLOGY
Create topology rules such as points must not overlap to check your data.
An overview of topology in ArcGIS—ArcMap | Documentation
Topology in ArcGIS—ArcGIS Pro | Documentation
2. ArcGIS Data Reviewer Extension
If you have the "ArcGIS Data Reviewer Extension" ArcMap or Pro then use the Reviewer Check Geometry Tool.
ArcGIS Data Reviewer checks—ArcGIS Pro | Documentation - "Check Geometry"
Checks in Data Reviewer—ArcMap | Documentation (arcgis.com) - "Invalid Geometry Check"
3. ArcGIS Data Interoperability Extension or FME Workbench
you can use Model Builder in ArcMap or Pro with the ArcGIS Data Interoperability Extension functions to check the geometry, the same can be done with FME Workbench.
What is the Data Interoperability extension?—ArcMap | Documentation (arcgis.com)
ArcGIS Data Interoperability extension for Desktop—ArcGIS Pro | Documentation
4. ST_GEOMETRY FUNCTIONS
ST_GEOMETRY ST_ISSIMPLE function
ST_IsSimple—ArcMap | Documentation (arcgis.com)
ST_GEOMETRY ST_ISEMPTY function
ST_IsEmpty—ArcMap | Documentation (arcgis.com)
For ArcGIS Pro
Databases and ST_Geometry—ArcGIS Pro | Documentation
stgeometry_reference.pdf (arcgis.com)
You must configure the oracle extproc.ora to access the ST_GEOMETRY library to be able to use ST_GEOMETRY functions in SQL statements.
Configure the extproc to access ST_Geometry in Oracle—ArcMap | Documentation (arcgis.com)
Configure extproc to access ST_Geometry in Oracle—ArcGIS Pro | Documentation
I hope this helps.
| 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