Tag Archives: Data Pump

ZDM hints and tips: “No such file or directory” when the dump file actually exists?

Leave a reply
Photo by Nitin Mathew on Unsplash

As I work more and more with the Oracle Zero Downtime Migration tool, I also encounter more and more specific problems. And if I manage to (sometimes) find solutions, then why not share them in the form of small blog posts? 1

I will not present ZDM on this blog, as the official documentation as well as my Oracle colleagues are doing a fantastic job exploring the multiple aspects of ZDM. You’ll find references at the end of this post2.

Recently, I was performing a logical online migration using Oracle ZDM on the following environments:

  • Source: On-premises standalone Oracle Database 12.1 non-CDB
  • Target: OCI DBCS 2-node RAC Oracle Database 21c multitenant PDB

Everything went well during the -eval process, but then the phase ZDM_DATAPUMP_IMPORT_TGT failed during the migrate process:

Continue reading →

My favorite column ever: ORACLE_MAINTAINED #JoelKallmanDay

Leave a reply
Photo by Eugeniya Belova on Unsplash

Even with all my good intentions, work and life challenges got in the way, and I have not been able to blog this year yet.
I still wanted to take part in the #JoelKallmanDay to honor Joel’s memory and to show my gratitude to the Oracle community.
In my (not so) new job at Oracle, I specialize in database migrations in the Cloud, with all sorts of databases and various migration strategies.
A quite common strategy is to use the powerful Oracle Data Pump utility. This blog post will not be about Data Pump, but rather about a very specific column in the dictionary views that I love very much, and that I use every minute of each of my work days (ok, I may be exaggerating a little): ORACLE_MAINTAINED

Continue reading →