Category: Oracle Database General

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

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

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

I am quarterly writing a post dissecting the changes implemented by Oracle CPUs so we can understand better the modifications implemented by Oracle in our Databases. The following patches were analysed: 11.2.0.4 11.2.0.4.210420 DB PSU 11.2.0.4.210420 Exadata Bundle Patch 11.2.0.4.210420 OJVM PSU 12.1.0.2 12.1.0.2.210420 DB PSU 12.1.0.2.210420 Exadata Bundle Patch 12.1.0.2.210420 OJVM PSU 12.2.0.1 12.2.0.1.210420 …

Continue reading