partitioning – Learning is not a spectator sport

Parallel DML and locking – going manual

Generally speaking, if you have a giant chunk of data over “here”, and you need to load it into a

Why interval partitioning is cool Before 11g, partitioning a table immediately stepped up the responsibilities of the database administrator, because

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