Switching a Multitenant Database to Extended Data Types
With Oracle 12c, Oracle introduced “extended data types”, which raise the limit for CHAR and VARCHAR2 datatypes from 4000 bytes to 32767 bytes. However, this is not the default setting and it takes some steps to change this setting. Especially in a Multitenant environment.
RMAN, PSU & DBBP
Last time I ran into an issue with RMAN when trying to register a new 12.1.0.2 database in my 12.1.0.2 RMAN catalog database.
Default administrative users when creating a PDB with DBCA
When creating a CDB and at least 1 PDB, DBCA creates the well known users SYS and SYSTEM and the user PDBADMIN. Where is this user created and which privileges are granted to PDBADMIN?