• About
  • All Posts
  • 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

Tag: partitioning

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

November 28, 2018 Uncategorized

The phantom tablespace

(Cueing my deep baritone Morpheus voice…) What if I told you that you can reference non-existent tablespaces in your DDL?

Continue reading

November 6, 2018 Uncategorized

Interval versus Range partitions

One of the nice things about partitioning in the database is that partition pruning can quickly eliminate the requirement to

Continue reading

October 5, 2018 Uncategorized

Partial Indexes–Take Care With Truncate

Partial indexes are a very cool feature that came along with Oracle 12c. The capability at partition level to control

Continue reading

September 17, 2018 Uncategorized

Partial indexing – get the dictionary definitions right

Just a quick post to clear up some confusion that can be seen on the partial indexing capabilities in Oracle

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.

Top Posts & Pages

  • New Year ... new idea ... new channel
  • How to do a GRANT on an entire schema
  • PL/SQL in 21c gets amazing new loop iterators
  • Why you keep getting "ORA-01653: unable to extend table"
  • No more stale statistics in 19c
  • NULL's vs NOT NULL's and Performance
  • Free In-memory in Oracle Database 19c
  • APEX 20.2 comes to town (well, to my PC)
  • DBMS_JOB - watching for failures
  • Updating indexes with partition maintenance
Blog at WordPress.com.
Learning is not a spectator sport
Blog at WordPress.com.
Cancel