topic Re: Can Oracle Data Pump migrate Utility Network and associated Dataset? in ArcGIS Utility Network Questions

Can Oracle Data Pump migrate Utility Network and associated Dataset?

Yogesh_Chavan — Mon, 20 Jan 2025 14:25:22 GMT

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!!

Re: Can Oracle Data Pump migrate Utility Network and associated Dataset?

Jens_Dalsgaard — Mon, 20 Jan 2025 09:31:53 GMT

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.

Re: Can Oracle Data Pump migrate Utility Network and associated Dataset?

Jens_Dalsgaard — Mon, 20 Jan 2025 09:35:47 GMT

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-asset-package.htm

Re: Can Oracle Data Pump migrate Utility Network and associated Dataset?

Yogesh_Chavan — Mon, 20 Jan 2025 13:16:25 GMT

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.

Re: Can Oracle Data Pump migrate Utility Network and associated Dataset?

Jens_Dalsgaard — Mon, 20 Jan 2025 14:00:08 GMT

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. 🙂

Re: Can Oracle Data Pump migrate Utility Network and associated Dataset?

MarceloMarques — Mon, 20 Jan 2025 19:34:05 GMT

@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

Re: Can Oracle Data Pump migrate Utility Network and associated Dataset?

Yogesh_Chavan — Tue, 21 Jan 2025 01:55:36 GMT

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?

Re: Can Oracle Data Pump migrate Utility Network and associated Dataset?

MarceloMarques — Tue, 21 Jan 2025 17:40:13 GMT

@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.