Sometimes, I have to debug and troubleshoot something, and I see myself in a position where I need to get the dictionary code of internal Oracle objects, and the most common way to do that is using DBMS_METADATA.
Let's say, for example, that I need to get the view SQL code for DBA_USERS we had back in 12.2.0.1 with April 2022 patch applied. Or if I need to get all the Package Specs for DBMS_STATS on 19c to check what is new compared with 18c? To achieve that, you would first need to install that release, apply the desired patch, and finally connect to the database to get the code using DBMS_METADATA.
Did you know that it is possible to get all that information without even having to download or install an Oracle Database? Check the short 2-minute video below to get this quick tip.
As ORAdiff has more than 500 hundred different version levels, you can get the contents of a very specific release in an easy way.
Try it out and let me know your input!
Have you enjoyed? Please leave a comment or give a 👍!
