Category Archives: Oracle 12c

Interval-Reference-Partitioning: Partition-Merge and Row-Movement

As often, I use this blog to answer questions of training participants. This time, it’s the question what happens on interval-reference-partitioned tables when merging partitions or when updates cause row movement.

Posted in Common, Oracle 12c | Leave a comment

ORACLE_MAINTAINED database users, part 2

Some time ago I wrote on ORACLE_MAINTAINED database users in Oracle 12c. Next question is: how are these users connected to database features and can the users be dropped – and if yes, how?

Posted in Common, Oracle 12c | Comments Off on ORACLE_MAINTAINED database users, part 2

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 Oracle 12c | Comments Off on Switching a Multitenant Database to Extended Data Types

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.

Posted in Oracle 12c | Comments Off on RMAN, PSU & DBBP

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 Common, Oracle 12c | Comments Off on Default administrative users when creating a PDB with DBCA