• About
  • All Posts
  • The Podcast!
  • Playlists
  • Golden Oldies
Skip to content

Learning is not a spectator sport

  • 30 second guide to India
  • About
  • Archives
  • Golden Oldies
    • First match
    • Smart DBA
  • Playlists
  • The Podcast!

Tag: partitioning

September 9, 2022 Uncategorized

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

Continue reading

a set of square shelves each holding various jars of spices being a metaphor for a database partitioned table
April 22, 2022 Uncategorized

Implementing dynamic partitions AND subpartitions

One of the cool things to come out of the partitioning option many moons ago was the feature known as

Continue reading

June 4, 2021 Uncategorized

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

Continue reading

May 31, 2021 Uncategorized

Data loads on INTERVAL partitioned tables

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

Continue reading

June 18, 2020 Uncategorized

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

Continue reading

April 30, 2020 Uncategorized

Why you might add columns to external tables

Let me start with the idiotic part first. That part would be…. me! I’ll create an external table which reads

Continue reading

July 8, 2019 Uncategorized

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

Continue reading

June 29, 2019 Uncategorized

MERGE and ORA-8006

I’m sure there will be a slew of post-Kscope wrap up posts coming out into the blogosphere, so in lieu

Continue reading

May 2, 2019 Uncategorized

Partition loading in direct mode

Direct mode insert using the APPEND hint is a cool piece of technology that lets you load bulk data into

Continue reading

April 29, 2019 Uncategorized

Raw partitions?

Here’s a quirky one for you. It can happen when you are dealing with a partitioned table where the partition

Continue reading

Posts navigation

1 2 3 4 Next Posts»

Over 500 posts …

Let’s connect

  • View connor_mc_d’s profile on Twitter
  • View connor_mc_d’s profile on Instagram
  • View connor-mcdonald-australia’s profile on LinkedIn
  • View UCVN7PnJnuKQ65QLmWjFvhiw’s profile on YouTube

Hi I'm Connor McDonald. I love playing with and exploring the Oracle database. But most of all I like seeing people succeed with the technology.
 
Subscribe for new posts by email.

Tweets by connor_mc_d

    Top Posts & Pages

    • The new forums
    • How to do a GRANT on an entire schema
    • The simple fix to date queries
    • How to TREAT data in a CLOB as JSON
    • Generating INSERT scripts that run fast!
    • Connection shortcuts with a wallet
    • Why you keep getting "ORA-01653: unable to extend table"
    • How to generate random unique values
    • No more stale statistics in 19c
    • Digging deeper into SQL under APEX
    Blog at WordPress.com.
    • Follow Following
      • Learning is not a spectator sport
      • Join 848 other followers
      • Already have a WordPress.com account? Log in now.
      • Learning is not a spectator sport
      • Customize
      • Follow Following
      • Sign up
      • Log in
      • Report this content
      • View site in Reader
      • Manage subscriptions
      • Collapse this bar
     

    Loading Comments...