Video : Multitenant : Online Move of Datafiles in CDBs and PDBs

Today’s video is a quick look at online datafile moves in container databases (CDBs) and pluggable databases (PDBs).

If you’ve used this functionality in a non-CDB database, it’s going to look familiar, with a PDB-specific gotcha.

These articles discus moving and renaming files.

I’ve added this to my Multitenant YouTube playlist.

The star of today’s video is Todd Trichler, but he’s having the share the limelight with the top of Roel Hartman‘s head, and brief clips of John King and Debra Lilley on the video screen behind him.



Reclaiming Unused Space in Datafiles…

Most of the time I write about stuff I’m interested in, but occasionally I’m forced into writing something to prevent me answering the same question again and again. This is one of those moments and it’s been several years in the making. The last time I tried to muster up the enthusiasm was on a flight last year and I got so bored I fell asleep.

Well today I finally got round to putting it together, so next time I get asked something like,

“I’ve moved a table to a new tablespace, how do I free up the space in the original datafile?”

I can answer, read this:

If you already know the answer, please don’t read it. I don’t want to be responsible for you falling asleep at your desk and losing your job. 🙂