Export feature class results in less features in output

Question

Hi,

I am exporting one feature class from a geodatabase (Oracle) to another geodatabase (Oracle) using the Feature Class To Feature Class tool but the resulting feature layer have less features than expected. My source have around 12M features, and the output from the tool varies with each run going from 300k to 1M.

The source feature class was created in SQL. Registering the table or not in the geodatabase does not change the result.

I have also tried running the same export through arcpy (using CopyFeatures, FeatureClassToGeodatabase, etc.) while forcing the environment extent to 'MAXOF', but the results are the same with different count nowhere near what is expected.

EOCWD_GIS · Accepted Answer

Here are some steps I'd try:

* Run Check / Repair Geometry geoprocessing tools
* Export the feature class to an empty geodatabase
* Break up the feature class into smaller groups
* Run the export in Catalog, not Pro
* If it still fails, run the export in ArcCatalog