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

October 29, 2021 Uncategorized

Keeping my SQLcl toasty fresh!

With the recent change to the licensing rules for SQLcl, a simple “yum” command on your Linux box gets you

Continue reading

October 7, 2021 Uncategorized

The HOST command in SQL*Plus and SQLcl

Truth be told, the original title of this post was going to be “How I lost an entire day debugging

Continue reading

July 30, 2021 Uncategorized

Time zones, blockchain and stopping hackers

I posted a few months ago about the availability of blockchain tables in 19c, and a fundamental mantra with anything

Continue reading

July 19, 2021 Uncategorized

Drop all baselines

Just a quick tip today on doing a “reset” on your optimizer environment. SQL Plan Baselines are an awesome tool

Continue reading

July 9, 2021 Uncategorized

Keeping OPatch updated with a simple SQL query

I tweeted out this pic yesterday which suggested that by running a SQL query, I could magically keep my OPatch

Continue reading

November 6, 2020 Uncategorized

Application Express – the PSE update

I published a post a couple of days ago about how due to the architecture of PL/SQL and hence Application

Continue reading

November 5, 2020 Uncategorized

Updating my APEX 20.2 installation

One of (or should I say “another of”!) the very cool features of Application Express (APEX) is that by being

Continue reading

October 27, 2020 Uncategorized

APEX 20.2 comes to town (well, to my PC)

As always, you should read the Installation/Upgrade manual from top to bottom before upgrading any piece of software, and be

Continue reading

19c scheduler and jobs
September 3, 2020 Uncategorized

DBMS_JOB and 19c – code changes needed

Sep 2021: Important update at tail of this post Here’s a “gotcha” brought to my attention by one of our

Continue reading

August 21, 2020 Uncategorized

How to upgrade to Oracle 19.8 on Windows

As always, you should follow the instructions in the README.html that comes with the Release Update, but because I know

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

  • How to do a GRANT on an entire schema
  • Version 7 was so much better...
  • The Fractional Part of a TIMESTAMP. Be careful.
  • Why you keep getting "ORA-01653: unable to extend table"
  • How to TREAT data in a CLOB as JSON
  • Connection shortcuts with a wallet
  • A little known RI clause
  • No more stale statistics in 19c
  • Automatically generate audit capture for tables
  • MERGE and ORA-30926
Blog at WordPress.com.
Learning is not a spectator sport
Blog at WordPress.com.
  • Follow Following
    • Learning is not a spectator sport
    • Join 810 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...