I am adding some data using session manager to layer, and saving them. Those changes are visible in delta table in SDE also. But, when I query to count the base table and versioned view result count, it is same as base table.

I want the base table will give actual count, and versioned view = basetable + delta changes

Using ArcMap 10.6.1, and Oracle as database.

  • Your changes will not be migrated from the delta table until you post and reconcile the versioned layer to base. Once you have done that, the base table should show the right number of features.
    – RomaH
    Dec 7, 2021 at 17:43
  • Is this data specific? Dec 7, 2021 at 17:56
  • @Yogi No, I don't think it is data specific issue. it is related to Arcmap/FM Dec 7, 2021 at 18:07
  • Are you running EXEC sde.set_current_version 'version-session-name'; and then your query?
    – RomaH
    Dec 7, 2021 at 18:40
  • @RomaH yes, I tried this query also, and didn't found answer Dec 7, 2021 at 19:10


Your Answer

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