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

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

April 27, 2021 Uncategorized

Why does SUM look broken for window functions?

TL;DR: SUM is NOT broken A quandary from a work colleague this morning about rolling totals via the SUM aggregation

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

August 7, 2020 Uncategorized

How to change Scheduler maintenance windows

There are a few possible reasons why you might be one of those people why you might be using your

Continue reading

June 15, 2020 Uncategorized

Upgrading from 19.6 to 19.7 on Windows

I must say this Release Update (RU) was probably the smoothest I’ve ever done. Obviously you should always read the

Continue reading

December 12, 2019 Uncategorized

dbca silent mode – Windows

Just a quick tip that often catches me out. If you are like me, you have long since tired of

Continue reading

March 8, 2019 Uncategorized

External table preprocessor on Windows

There are plenty of blog posts about using the pre-processor facility in external tables to get OS level information available

Continue reading

January 22, 2019 Uncategorized

Patch conflicts

My last post was about patching my home databases from 18.3 to 18.5 on Windows, and how I encountered a

Continue reading

August 27, 2018 Uncategorized

18c database creation on Windows

Hopefully you’ve followed my very simple and easy guide to downloading the 18c database software for Windows. But of course,

Continue reading

August 24, 2018 Uncategorized

18c Database installation on Windows

If you’re a Windows enterprise, or you want to run your 18c database on your Windows laptop/desktop for research 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