partitioning – Learning is not a spectator sport

Adding columns to external tables…idiocy?

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