dba – Learning is not a spectator sport

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

The recyclebin is a very cool feature in the Oracle Database, and a great “Get of our jail free” card

In 12c, we introduced a feature call Row Archival, which is a means of integrating typical archival models that we

Full disclosure: This is a rant post. If you’re not into ranting and pontificating, perhaps best to move along now

One of the cool things to come out of the partitioning option many moons ago was the feature known as

Just a quick tip on using DBMS_METADATA that caught me out the other day. If you have a table and

Handling default values on columns has been an age old problem that we solved in 12c with extensions to the

I tweeted this snippet the other day because to be honest I was just overjoyed about being able to get

Nearly 10 years ago(!!!) I blogged about how you can toggle columns to invisible and back again as a means

The database on my laptop seemed slow this morning. Normally I would put this down to the fact that I’ve