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
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