partitioning – Learning is not a spectator sport

Take care with Read-Only partitions in 18c

The ability for part of a table to be read-only and other parts of the same table to allow full

Let me start with the idiotic part first. That part would be…. me! I’ll create an external table which reads

Just a quick post to ensure people don’t get caught out by a recent “trick” I saw on an AskTOM

I’m sure there will be a slew of post-Kscope wrap up posts coming out into the blogosphere, so in lieu

Direct mode insert using the APPEND hint is a cool piece of technology that lets you load bulk data into

Here’s a quirky one for you. It can happen when you are dealing with a partitioned table where the partition

(Cueing my deep baritone Morpheus voice…) What if I told you that you can reference non-existent tablespaces in your DDL?

One of the nice things about partitioning in the database is that partition pruning can quickly eliminate the requirement to

Partial indexes are a very cool feature that came along with Oracle 12c. The capability at partition level to control

Just a quick post to clear up some confusion that can be seen on the partial indexing capabilities in Oracle