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
One of the cool things to come out of the partitioning option many moons ago was the feature known as
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