Jul 13

Local Undo and Compatible 12.1.0.2 ?

Imagine you want to migrate your Oracle Database from 12.1.0.2 to 19c. To allow a fallback plan, you most probably will create your 19c database with the same COMPATIBLE as the source database, 12.1.0.2.0. Talking now about Local Undo, it was first released on 12.2. So what if I try to create my 19c with …

Continue reading

Jul 12

Tranportable Tablespace to lower release? Is it possible?

Today my experiment will be trying to run a transportable tablespace to a lower release. The reason for this experiment is to evaluate a possible fast fallback plan in case I want to roll back a migration+upgrade (eg: 12c NON-CDB to 19c PDB). The first important thing to note is that the non-cdb to pdb …

Continue reading

Jul 09

Creating a 19c database with a lower COMPATIBLE parameter

Those days, I was trying to create a 19c database with a lower COMPATIBLE, so I could have a fallback plan after plugin a PDB from a lower release. However, when trying to create it using DBCA command: dbca -silent -createDatabase \ -gdbName cdb19c \ -templateName General_Purpose.dbc \ -characterSet AL32UTF8 \ -createAsContainerDatabase true \ -numberOfPDBs …

Continue reading

Jun 08

Heading to the mothership!

Hello World! I’m extremely happy and excited to announce that, this week, I’ve just started a new Product Manager role at Oracle! I’m joining Roy Swonger, Mike Dietrich, Daniel Hansen and Bill Beauregard on the Oracle Database Migrations, Upgrades, Patching and Utilities PM team! After working more than 15 years on companies like IBM, Capgemini, …

Continue reading

Apr 30

New DBA_IMMUTABLE_TABLES view, starting on 19.11

If you follow my quarterly dissecting database patches series, you will note that on 19.11 (April-2021 CPU) oracle introduced a new USER/ALL/DBA_IMMUTABLE_TABLES view. This seems to be related with the new blockchain feature, but on 19.10 (the previous RU), oracle have already created USER/ALL/DBA_BLOCKCHAIN_TABLES. In this post I will investigate the differences among them. So, …

Continue reading