dba – Page 2 – Learning is not a spectator sport

INTERVAL partitions in multiple tablespaces

When the “STORE IN” clause is mentioned for partitioned tables, most people’s mind turn toward hash partitioning, because the usage

Here’s something to be careful with when it comes to using DBMS_REDEFINITION. Let’s start with the following scenario. I have

Well….that blew up! 😀 Last week I published a video (which you can watch below if you haven’t seen it)

As many readers will be aware, we introduced a cool new JSON datatype in 21c which offers more features and

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