We have a versioned table of polygons and one of our users have deleted every geometries.

With Oracle's SQL Developer, i can see the table still containing the missing data, along with its Axxxx and Dxxxx tables, representing the versioned actions (the Axxxx table stores the data added to our table and the Dxxxx the row number of the deleted data).

I understand that ArcGIS Desktop use an Oracle View that computes the added and deleted data to the table.

Is there a way to restore or undelete those polygons (and their attributes) ? Can I just empty that Dxxxx table, which contains row numbers of the deleted polygons ?

We have ArcGIS Server 10.2.2, ArcGIS Desktop 10.4 and Oracle 11.

  • 1
    do you have a backup? – Mapperz May 15 '18 at 13:56
  • of course, but isn't it also the purpose of a versioned table, to be able to step back from edits ? – LMokrane May 15 '18 at 14:04
  • 1
    It depends on how far your automation has prepared to accept those edits. They haven't been deleted yet, but they may be entangled in other edits in the same version lineage. If they're isolated, all you need to do is move the version to the start of the tree where deletion occurred. You should only hack the Dn table under direction from Tech Support. – Vince May 15 '18 at 14:21
  • Has the delete propagated to the default table or are you looking at the Table view? (ex. TableName_evw) You say you can see the table with the missing data. Which table? – Simon.y May 15 '18 at 15:57
  • the view tablename_evw has no data. the delete has not propagate to the table tablename, it still has all the data (332 rows) – LMokrane May 17 '18 at 10:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.