DBMS_METADATA for INDEXES
Just a quick tip on using DBMS_METADATA that caught me out the other day. If you have a table and
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
SQL loader is a very cool utility that has existed for a long time within Oracle to load flat files