I am using SQL in Oracle to fill and empty feature class table, basically something like this:


The SQL runs and the table in the database gets filled, but in arcMAP when opening the feature it is totally empty, therefore there is out of sync between ArcSDE and Database.

I have restarted ArcGIS connection and ArcMAP and no success, probably there is some trigger on ArcSDE or metadata that needs to be updated. Any tips on what could I do?

ArcGIS version: 10.6.1 Database: Oracle

  • 1
    Is the feature in ArcSDE versioned?
    – danak
    Oct 15, 2018 at 15:47
  • 1
    If you use versioning or archiving, you should not modify the table directly, but modify the "_evw" view instead (ie, DAMO_W.BRUG_EVW). ArcGIS SDE geodatabases have a lot of complicated interactions between various tables and views, and if you try to manipulated them directly, you risk corrupting the database, or otherwise ending up with unexpected results. The officially supported procedure for editing an SDE database with SQL is at: desktop.arcgis.com/en/arcmap/latest/manage-data/… Oct 15, 2018 at 22:52
  • The version and archiving is off. Oct 18, 2018 at 7:54
  • It is very possible that the objectid column ios the problem. tables regiserted with the geodatabase have a stored procedure or trigger (can't remember which) to generate OBJECTID values for each insert. If you are working with a geodatabase then you are better off using geodatabase tools to move data. Instead of SQL use the geoprocessing tools truncate and append, or delete and copy to move data.
    – Dowlers
    Oct 29, 2018 at 14:38

1 Answer 1


For the data to appear in ArcMap it was necessary to commit on the database:


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.