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