Twitter
-
IT-Tage 2019
-
Book: Oracle DBA (Amazon)
About me ..
Legal Stuff ..
-
Recent Posts
Archives
- November 2019
- September 2019
- August 2019
- May 2019
- April 2019
- December 2018
- November 2018
- August 2018
- July 2018
- June 2018
- April 2018
- March 2018
- January 2018
- November 2017
- October 2017
- September 2017
- August 2017
- July 2017
- June 2017
- May 2017
- February 2017
- December 2016
- November 2016
- October 2016
- July 2016
- June 2016
- December 2015
- November 2015
- September 2015
- August 2015
- July 2015
- April 2015
Categories
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