I have lost all data from default version and also from the base tables in Oracle. But luckily, there is a version that has all the data in it. I have reconciled and posted that version to default but since the data is already there in that version and I haven't made any changes yet therefore default version is still empty.

Is there any way to restore the data from that version to default version?

I don't want to import data in base tables directly but from ArcMap so that I can bring everything to its original state.

  • 1
    If your database instance has been horrifically corrupted, you really ought to be talking to Tech Support. They can talk you though the procedures necessary to preserve whatever you have left. At this point, you should have a sequestered before backup, an as-is database backup, and be prepared to rollback to the before backup. – Vince Jul 5 '19 at 14:05
  • Maybe the database is not corrupt, someone might have deleted the data mistakenly. Is there any option to rollback to previous state? – Ayaz49 Jul 5 '19 at 14:11
  • 1
    Use your last full backup before the corruption. Or talk to Tech Support – Vince Jul 5 '19 at 14:54
  • 1
    If you can see the data in a child version but not in default then the first thing I would do is export to a new feature class from that version so you have a copy of the data. After that you can try restoring from backups or other approaches. If they fail at least you can reload from your copy. – Dowlers Jul 6 '19 at 16:56
  • How can I load the data in default version rather than base table? – Ayaz49 Jul 7 '19 at 15:15