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
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