I am using SQL in Oracle to fill and empty feature class table, basically something like this:
INSERT INTO DAMO_W.BRUG (OBJECTID,CODE,NAAM,GLOBALID,SHAPE,CREATED_USER,CREATED_DATE,LAST_EDITED_DATE,LAST_EDITED_USER) SELECT OBJECTID, CODE, NAAM, GLOBALID,SHAPE,CREATED_USER,CREATED_DATE,LAST_EDITED_DATE,LAST_EDITED_USER FROM WS_BRUG;
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