Category Archives: Multitenant

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 … Continue reading

Posted in Multitenant, Oracle 12c | Comments Off on Switching a Multitenant Database to Extended Data Types

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?

Posted in Multitenant, Oracle 12c | Comments Off on Default administrative users when creating a PDB with DBCA

CDB architecture, multitenant architecture – what’s the correct naming?

After an internal discussion at Trivadis, I thought about the naming conventions for database architectures in Oracle Database 12c. Many people call the “new architecture” “multitenant architecture”. This can result in some confusion because the “Multitenant Option” is an extra-cost … Continue reading

Posted in Multitenant, Oracle 12c | Comments Off on CDB architecture, multitenant architecture – what’s the correct naming?

Pluggable Databases and “DATA_PUMP_DIR” – ORA-39087

Some days ago I ran into the issue that using the directory “DATA_PUMP_DIR”, which is created in every Oracle 12c database, cannot be using when exporting data of a PDB. This is documented in the “Utilities Guide” (Chapter „Overview of … Continue reading

Posted in Common, Multitenant | Comments Off on Pluggable Databases and “DATA_PUMP_DIR” – ORA-39087