ddl – Learning is not a spectator sport

DBMS_METADATA – hitting its limit

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

This one caught me out – I was racing around looking for bugs, or parameter files, or hidden settings that

I came across an interesting blog post the other day about whether databases should be (declaratively) enforcing the foreign key

I’ve always been worried about taking a script that is fine to run in my non-production environments (in particular a