dba – Learning is not a spectator sport

Plugzilla!

Cloning a pluggable database takes time, and for environments where you’d like to use clones as part of unit testing,

In the recent versions of the Oracle database, we’ve had the ability to convert between a System Change Number (SCN)

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

Direct mode insert using the APPEND hint is a cool piece of technology that lets you load bulk data into

Here’s a quirky one for you. It can happen when you are dealing with a partitioned table where the partition

I posted a video a couple of days ago showing a trigger mechanism to customize the capture of DDL that

AskTOM moved to Application Express 19.1 without any major issues last weekend. That in itself is a nice endorsement for