Comparing two database objects for differences
Ask an Oracle practitioner what DBMS_METADATA is used for, and they’ll (correctly) tell you it used to retrieve the DDL
Ask an Oracle practitioner what DBMS_METADATA is used for, and they’ll (correctly) tell you it used to retrieve the DDL
Just a quick tip on using DBMS_METADATA that caught me out the other day. If you have a table and
Most of us with any kind of longevity in the Oracle world will remember the days when we wrote our
There are plenty of tools out there that you can use to get DDL scripts for various objects in the
I was helping out a customer today with what they thought was a bug in DBMS_METADATA. They were using it
First things first. If you are not familiar with the term “gets my goat” then you can find a definition
I stumbled upon this post by optimizer guru Nigel Bayliss last week, so please have a read of that first
This one came in via an AskTOM question. You need to be careful when disabling constraints that are underpinned by
I posted a video a couple of days ago showing a trigger mechanism to customize the capture of DDL that
The DBMS_METADATA package is very cool. I remember the days of either hand-crafting DDL statements based on queries to the