Learning is not a spectator sport

MERGE and ORA-8006

I’m sure there will be a slew of post-Kscope wrap up posts coming out into the blogosphere, so in lieu

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

Yeah yeah I know. What kind of dufus cut-pastes a giant image into their blog post. That would be …..

OK, let’s be honest right up front. The motivation for this post is solely to be able to roll out

If you have performed some sort of data cleanup or similar on a table, then the deleted space will be

There’s a hesitation to publish this example, because publishing it may be interpreted as an endorsement of this approach and

This is a followup to yesterdays post on DBMS_JOB and is critical if you’re upgrading to 19c soon. Mike Dietrich