(Scott Wesley) I have a diagnostic page where I hide classic report regions that aren’t relevant – ie, have no data returned.
Tag: Oracle
18c database creation on Windows
(Connor McDonald) 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!
Convert Regular PDB to Application PDB
(Jagruti Jasleniya) In this article, we will see converting regular PDB to Application PDB.
APEX New Workspace
(Michael McLaughlin) After you install APEX or upgrade a base APEX, you need to create workspaces. These instructions show you how to create a workspace in APEX 18.
RMAN: Synchronize standby database using production archivelog backupset
(mdinh) If you have not read RMAN: Synchronize standby database using production archivelog, then please do so.
Take care with regular expressions
(Connor McDonald) In an Office Hours session a couple of months back, I covered an important change that comes to regular expressions once you upgrade to 12c Release 2.
June 23 2019, date of the SCN-bug
(Job Oprel) The what? I read about the SCN bug a few years ago (a wildly increasing value of the SCN till a certain limit has been reached ) , and took this for granted – most of it.
APEX 4 to 18 Upgrade
(Michael McLaughlin) While preparing my new instance for class, which uses Oracle 11g XE and Fedora 27, I got caught by the Oracle instructions. I should have got caught but when you’re in a hurry sometimes you don’t slow down enough to read it properly.
RMAN: Synchronize standby database using production archivelog
(mdinh) I know what you are thinking, “Why is this nut of a DBA writing shell script to synchronize standby with achivelog !”
Gooey GUIDs
(Connor McDonald) Do a quick Google search and you’ll find plenty of blog posts about why GUIDs are superior to integers for a unique identifier, and of course, an equal number of posts about why integers are superior to GUIDs.
