Locking & unlocking common users in a Multitenant database
Common users in a multitenant database are defined in CDB$ROOT and are then available in all PDBs. Privileges can be granted locally (for a single container) or for the whole container database (CONTAINER=ALL). But what about locking and unlocking these users on the different level.
Oracle Multitenant: From OMF-PDB to Non-OMF-PDB
Personally, I prefer running Oracle Container Databases with Oracle Managed Files (OMF), because OMF simplify the handling of the filenames, especially when cloning pluggable databases. But if you are running a “mixed environment” with some databases using OMF and others not, it may occur that you have to plugin an “OMF-PDB” as a “Non-OMF-PDB”. Let’s…
Refreshable PDBs and the Archivelog Deletion Policy
Refreshable PDBs are a cool thing within the Oracle Multitenant Architecture. You can create a copy of your large production database once and later you can „refresh“ it by applying the transactions (redologs) from the source database. But keep in mind that your archivelog deletion policy may kick in and can destroy your refresh mechanism.