• 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: merge

November 12, 2021 Uncategorized

Formula 1 data–staying up to date

Just an addenda to what I posted last week about downloading the Formula 1 motor racing data where I provided

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

February 18, 2019 Uncategorized

MERGE and ORA-30926

Just a quick blog post on MERGE and the “unable to get a stable set of rows” error that often

Continue reading

July 25, 2018 Uncategorized

Hyper-partitioned index avoidance

As you can tell, I have no idea on a name for what I am about to describe. So let

Continue reading

February 27, 2018 Uncategorized

18c merge partition online

One of the cool things in 18c is the ability to merge partitions without causing a service interruption.  Here’s a

Continue reading

August 17, 2014 Uncategorized

MERGE and IOT’s ….. unhappy bedfellows

Anyone who has used Oracle for a while will be familiar with the Parent/Child locking “issue” when it comes to

Continue reading

March 29, 2013 Uncategorized

MERGE – concise syntax but not always fastest

A long time ago … a long long time ago (http://www.oracledba.co.uk/tips/merge_speed.htm) I wrote that MERGE works best over update and

Continue reading

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

    • How to do a GRANT on an entire schema
    • No more stale statistics in 19c
    • Why you keep getting "ORA-01653: unable to extend table"
    • 19c Express Edition #JoelKallmanDay
    • How to TREAT data in a CLOB as JSON
    • The phantom tablespace
    • Connection shortcuts with a wallet
    • Automatically generate audit capture for tables
    • ORDS upgrades are so easy
    • HIGH_VALUE (and other LONG columns) revisited
    Blog at WordPress.com.
    • Follow Following
      • Learning is not a spectator sport
      • Join 852 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