topic Re: Oracle SDE Upgrade and Feature Datasets in Geodatabase Questions

Oracle SDE Upgrade and Feature Datasets

GeorgeKatsambas — Mon, 14 May 2018 14:17:30 GMT

I am reaching out as I came across some posts on geonet and even though I have contacted ESRI support I am hoping for help in some way. In SDE Oracle 11g I had a feature database with some editable feature classes with attachments enabled, these also were published as map services and used in Collector App. However, when we upgraded to the new SDE oracle database,12 g, the feature classes were copied however the feature dataset was not. I need the feature dataset to be recreated as i have scripts using the feature dataset. If I try to create the feaure dataset with the original feature classes I will loose my existing attachments. Also in Collector the map services referencing the Feature Dataset are there but no attachments or ability to load attachments is possible as the original feature dataset and attach/rel tables are no longer in the feature dataset, even though they are in the SDE FGB. Is there any way to recreate the original feature dataset with the original feature classes and same attach/rel tables?

Re: Oracle SDE Upgrade and Feature Datasets

George_Thompson — Mon, 14 May 2018 15:10:38 GMT

How was the data copied over to the new Oracle 12c instance?

If ArcGIS Pro/Map was used, why did only the feature classes get copied over? What was the version of the ArcGIS client used to move the data?

Re: Oracle SDE Upgrade and Feature Datasets

GeorgeKatsambas — Mon, 14 May 2018 15:25:53 GMT

It was all done through Oracle import/export no arcGIS Client

Re: Oracle SDE Upgrade and Feature Datasets

George_Thompson — Mon, 14 May 2018 15:29:19 GMT

If that is the case, then it sounds like something in the export/import did not work correctly. I have backed up/restore many Oracle geodatabases and the feature datasets are restored with no issues.

Where there any issues/errors during the export/import process?

Working with Esri Support, as you mentioned originally, may be the best course of action for this issue and it will more than likely require a very deep dive into the process and dump files.