Select to view content in your preferred language

Restore single SDE feature class

385
1
11-18-2010 02:31 PM
JaninaBarnes
New Contributor
A single feature set in my Oracle production database needs restored.  How do I replace the current feature class in PROD with the restored data?  A large number of records were dropped from that feature class and posted to base.  The next day, that FC's user discovered the missing data.  We have restored the database from the correct time to a temporary database.  The feature class is versioned in both databases and was / is actively being edited.  The user continued editing after discovering the missing data, so ideally we would be able to combine the old data with the new adds and deletes.
0 Kudos
1 Reply
JonHall
Frequent Contributor
If you can select-by-attribute in ArcMap (without using the advanced pre-VBA code option) and select only the records in the temporary database that you want to restore, then you should be able to use ArcCatalog to right-click on the Featureclass, and 'Load' > 'Load data', then use the option to 'Load only the features that satisfy a query'.

That will work, as long as the featureclass doesn't participate in an attributed or manay-to-many relationship class
0 Kudos