• 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: 18c

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

February 26, 2020 Uncategorized

When upgrading, choose 19c not 18c

I had someone say to me at an event recently: “We’re are going to upgrade to 18c, because 19c is

Continue reading

January 23, 2020 Uncategorized

Handling UTL_FILE_DIR and DIRECTORY objects

A couple of years back (wow…time flies!) I made a video and a post about the de-support of UTL_FILE_DIR in

Continue reading

May 28, 2019 Uncategorized

DBMS_JOB – the joy of transactions

This is a followup to yesterdays post on DBMS_JOB and is critical if you’re upgrading to 19c soon. Mike Dietrich

Continue reading

May 27, 2019 Uncategorized

DBMS_JOB – watching for failures

I had a friend point this one out to me recently. They use DBMS_JOB to allow some “fire and forget”

Continue reading

March 7, 2019 Uncategorized

Connections with a wallet – redux

Wow…it is nearly 4 years ago now that I wrote an article on connecting to the database via a wallet

Continue reading

February 21, 2019 Uncategorized

Worth the wait

Yes, I know it’s been awhile Yes, I know people have been angry at the delay But, can we put

Continue reading

January 19, 2019 Uncategorized

From Database 18.3 to 18.5 (on Windows)

Contrary to wild rumours on the internet, it was not a fear of the number 13 that led to a

Continue reading

November 23, 2018 Uncategorized

Happy Thanksgiving!

Just a quick blog post from Wellington New Zealand where we have just wrapped up the 2018 APAC Groundbreakers tour.

Continue reading

November 21, 2018 Uncategorized

18c and the ignoring of hints

  One of the new features in 18c is the ability to ignore any optimizer hints in a session or

Continue reading

Posts navigation

1 2 3 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...