Select to view content in your preferred language

Can Oracle Data Pump migrate Utility Network and associated Dataset?

268
7
Jump to solution
3 weeks ago
Yogesh_Chavan
Frequent Contributor

Can we get any ideas/confirmation if the Oracle Data Pump utility capable of migrating Utility Network, Utility Network Dataset and associated tables from one Oracle to another? 

In our data pump process, we only got the data and tables, but not in the correct structure(Dataset), with missing the Utility Network.

Just need confirmation if this process works for UN migration or not?

Thank you!!

0 Kudos
1 Solution

Accepted Solutions
MarceloMarques
Esri Regular Contributor

@Yogesh_Chavan 

Can Oracle Data Pump be used to move only the Geodatabase Utility Network?


No, Oracle Data Pump cannot move only the Geodatabase Utility Network.

Oracle Data Pump is used to move the entire Oracle Geodatabase. If the Geodatabase has Utility Network data, then all the Geodatabase datasets are moved as well.

If you want to move only the Geodatabase Utility Network data, you must use the ArcGIS UN Tools. Basically, you will have to rebuild the UN all over again in the other Oracle Geodatabase and then reload the data. This is a lot of work, especially if you have a large UN dataset.

Therefore, the best way to create a copy of the Oracle Geodatabase that has UN data is to use Oracle Data Pump. If that Oracle Geodatabase has UN data then the copy will be a fully functional Oracle ArcSDE Geodatabase with a fully functional UN dataset, just like in the source Oracle Geodatabase.

Or if you are using Oracle Pluggable Databases (PDBs) for the Oracle ArcSDE Geodatabase, then the Oracle Administrator can clone, make a copy, of the PDB using Oracle commands. The PDB can have a different name on the same Oracle Container Database (CDB), this will not break the ArcSDE Repository.

Therefore, the 2 best ways to create a copy or to move the Oracle ArcSDE Geodatabase is by using Oracle Data Pump or Oracle PDB cloning.

I hope this clarifies.

| Marcelo Marques | Esri Principal Product Engineer | Cloud & Database Administrator | OCP - Oracle Database Certified Professional | "In 1992, I embarked on my journey with Esri Technology, and since 1997, I have been working with ArcSDE Geodatabases, right from its initial release. Over the past 32 years, my passion for GIS has only grown stronger." | “ I do not fear computers. I fear the lack of them." Isaac Isimov |

View solution in original post

7 Replies
Jens_Dalsgaard
Frequent Contributor

Migrating to ArcGIS Utility Network is COMPLEX and it seems unlikely that a dump will accommodate ArcGIS UN requirements.

A dump at best would be the start of a migration process where data is transformed to comply to UN requirements.

Jens Dalsgaard
Principal Product Owner
Power Grid, V O L U E
jens.dalsgaard&@volue.com
Volue Technology Denmark A/S
Alfred Nobels Vej 27
9220 Aalborg Øst, Denmark
volue.com
0 Kudos
Yogesh_Chavan
Frequent Contributor

Hi @Jens_Dalsgaard,

I am sorry, but would like to know if you meant DUMP or PUMP? or do you mean Data PUMP are just DUMPS? 🙂

We already have a workflow at place to migrate UN from one DB to another using GP in ArcGIS Pro.

Here I wanted to just confirm if Oracle Data PUMP utility is capable of doing this or not? If in case anyone ever accomplished it successfully, coz in our try it just brought all the data directly in new dB missing the dataset, and network.

0 Kudos
Jens_Dalsgaard
Frequent Contributor

Reading some of your other posts, I get the impression that you're already well into UN. You have a fully functional UN and 'simply' want to replicate this. Or what.

My answer was given - sorry about that - based on the assumption that you thought - as I do find some thinking - that you can simply move data into ArcGIS UN and utility network will work. You're not there. 🙂

Jens Dalsgaard
Principal Product Owner
Power Grid, V O L U E
jens.dalsgaard&@volue.com
Volue Technology Denmark A/S
Alfred Nobels Vej 27
9220 Aalborg Øst, Denmark
volue.com
0 Kudos
Jens_Dalsgaard
Frequent Contributor

Re-reading your question I ask myself whether you're actually asking about migrating from one UN database to another UN database.

In that case, why wouldn't you use standard ArcGIS GP's? E.g. https://doc.arcgis.com/en/arcgis-solutions/latest/tool-reference/utility-network-package/export-asse...

Jens Dalsgaard
Principal Product Owner
Power Grid, V O L U E
jens.dalsgaard&@volue.com
Volue Technology Denmark A/S
Alfred Nobels Vej 27
9220 Aalborg Øst, Denmark
volue.com
0 Kudos
MarceloMarques
Esri Regular Contributor

@Yogesh_Chavan - You can use Oracle Data Pump to move the entire Oracle Geodatabase, the Geodatabase can contain Utility Network data, Topology, etc. For more information read my white paper below.

How to Move the Oracle Enterprise Geodatabase with the Oracle Data Pump Utility

For more best practices visit my community.esri.com blog 

Mapping and Charting Solutions (MCS) Enterprise Databases Best Practices

| Marcelo Marques | Esri Principal Product Engineer | Cloud & Database Administrator | OCP - Oracle Database Certified Professional | "In 1992, I embarked on my journey with Esri Technology, and since 1997, I have been working with ArcSDE Geodatabases, right from its initial release. Over the past 32 years, my passion for GIS has only grown stronger." | “ I do not fear computers. I fear the lack of them." Isaac Isimov |
0 Kudos
Yogesh_Chavan
Frequent Contributor

Thank you so much @MarceloMarques,

I have already seen this whitepaper, its really great.

As you mentioned "You can use Oracle Data Pump to move the entire Oracle Geodatabase, the Geodatabase can contain Utility Network data, Topology, etc".

My query is specific to the Utility Network that resides within the dataset. Does the data pump also move this Network? If yes, how does oracle sees this data format? In our testing we did not see this network in output DB. Or is it an expected behavior and we need to just stage and load asset to UNM using the moved data?

Yogesh_Chavan_0-1737424395297.png

 

0 Kudos
MarceloMarques
Esri Regular Contributor

@Yogesh_Chavan 

Can Oracle Data Pump be used to move only the Geodatabase Utility Network?


No, Oracle Data Pump cannot move only the Geodatabase Utility Network.

Oracle Data Pump is used to move the entire Oracle Geodatabase. If the Geodatabase has Utility Network data, then all the Geodatabase datasets are moved as well.

If you want to move only the Geodatabase Utility Network data, you must use the ArcGIS UN Tools. Basically, you will have to rebuild the UN all over again in the other Oracle Geodatabase and then reload the data. This is a lot of work, especially if you have a large UN dataset.

Therefore, the best way to create a copy of the Oracle Geodatabase that has UN data is to use Oracle Data Pump. If that Oracle Geodatabase has UN data then the copy will be a fully functional Oracle ArcSDE Geodatabase with a fully functional UN dataset, just like in the source Oracle Geodatabase.

Or if you are using Oracle Pluggable Databases (PDBs) for the Oracle ArcSDE Geodatabase, then the Oracle Administrator can clone, make a copy, of the PDB using Oracle commands. The PDB can have a different name on the same Oracle Container Database (CDB), this will not break the ArcSDE Repository.

Therefore, the 2 best ways to create a copy or to move the Oracle ArcSDE Geodatabase is by using Oracle Data Pump or Oracle PDB cloning.

I hope this clarifies.

| Marcelo Marques | Esri Principal Product Engineer | Cloud & Database Administrator | OCP - Oracle Database Certified Professional | "In 1992, I embarked on my journey with Esri Technology, and since 1997, I have been working with ArcSDE Geodatabases, right from its initial release. Over the past 32 years, my passion for GIS has only grown stronger." | “ I do not fear computers. I fear the lack of them." Isaac Isimov |