partitioning – Learning is not a spectator sport

HIGH_VALUE (and other LONG columns) revisited

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