query

Datapatch return codes and helpful queries

Posted on February 17, 2026 by datapatch 4

The other week I was visiting a customer in Germany who had specific questions for datapatch. And luckily, Alejandro Diaz who is the Product Manager for Data Pump in our team has a history in datapatch.  He helped me with Datapatch return codes and helpful queries.

Datapatch return codes

Yes, datapatch generates various return codes you can use to verify the outcome in case you program or maintain an automation.

  • 0 for success
  • 1 for prereq failure
  • 2 for non-ignorable error during patch installation
  • 255 runtime error

I may …

Continue reading...

ORA-43907: Potential behavior change with Oracle RU 19.28.0

Posted on September 22, 2025 by Behavior Change Oracle Database 19c Patch Recommendation 2

As I said multiple times, we have the best and most knowledgeable customers out there. Julian Frey is one of them, and there is a good and legit reason why he is an ACE Director since (I think) two years. Julian alerted me the other day about an ORA-43907: Potential behavior change with Oracle RU 19.28.0. And I guess, some of you would like to learn about this, too.

What you may see?

Oracle Database 19c Release Update 19.28 contains a fix for Bug 36386077 – ORA-43907 NEEDS TO BE RAISED FOR CONVERSION …

Continue reading...

Queries on dictionary tables are slow in Oracle Multitenant?

Posted on February 10, 2025 by Flaws and Pitfalls Single-/Multitenant 12

I love to learn something new every day. And on Friday afternoon last week I learned something new again. It started (as often) with a very simple question from a colleague working from the Oracle Malaga office in Spain. The customer has an issues with some queries being slower than before once they moved from on-prem to the cloud into a PDB. But are queries on dictionary tables are slow in Oracle Multitenant generally?

What was the case?

The customer ran some queries against dictionary views in the PDB in Oracle Database …

Continue reading...

ORAdiff is live – compare two Oracle Database and Patch releases

Posted on August 8, 2023 by ORAdiff 32

Did you ever wanted to find out the differences between two Oracle database releases? Today, I am super-super excited. Especially, since this was a long journey. And I have to thank our entire team,  Rodrigo especially but also Bill and all the others working and helping here. THIS is the tool many of you have looking for since years. It is time now, ORAdiff is live – compare two Oracle Database and Patch releases.

ORAdiff is live - compare two Oracle Database and Patch releases

What is ORAdiff?

This tool is made for you. It allows you to compare two Oracle releases to each other. And not only core …

Continue reading...
Mike Dietrich
Oracle Vice President of Product Management and Development for Database Upgrade, Cloud Migrations and Patching writing just another blog.

Opinions certainly are my own as is this page.

Archives

Categories

Upgrade @YouTube

Subscribe via Email

Join 11.3K other subscribers