Learning is not a spectator sport
Connor McDonald on SQL and the Oracle Database
Tag: 18c
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, software on its own is not much use – we need a database! So let’s get cracking and create one. Using the Start menu…
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 education, then there has been some good news this week. The software is now available to you on the OTN network page. Here’s a…
Hyper-partitioned index avoidance thingamajig
As you can tell, I have no idea on a name for what I am about to describe. So let me start from the beginning, and set the scene for an idea I have to utilize a cool new 18c feature. Often in a…
18.3 As easy as 1…2…3
Well, finally it’s here! 18c for on-premise installation so the world can all get stuck into the cool new features of the latest release on their own laptops At least that is what I’ll be doing! Naturally as soon as I heard the…
UTL_FILE_DIR and 18c
I wrote a blog post called The Death of UTL_FILE which attracted a comment from a reader: “There is NO chance to stay at UTL_FILE as it is DESUPPORTED starting with database Version 18c” This is not the case, but since I wanted to…
18.2 patch… painless for me
18.2 was released a few days ago, so I thought I’d throw it against my 18c instance and see how things played out. This was just a single instance database, running with a single pluggable. Step 1 for me was to download the latest…
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 video demonstration of that in action: This is just an accompanying blog post to let you grab the scripts for the demo so that…
18c–If you can’t wait
You’ve seen the tweet !! but perhaps the accompanying blog post has tempered your enthusiasm You might be thinking: “I’m not on Exadata – how can I play with 18c?” Well, there is still a way to get ahead of the game and skill…
Oracle Database 18c
Yup…it’s arrived! New name obviously, because we’ve jumped to our new naming model to align with the calendar year as opposed to version number. You might be thinking “So what?” but it’s a significant change in the way we getting software to customer. Mike…
