Category Archives: Common

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 | Comments Off on Interval-Reference-Partitioning: Partition-Merge and Row-Movement

Which node is the OCR master node (AKA “OCR writer”) in a RAC?

There are several ways to answer this question: Look for “OCR master” in the log files of crsd and check olsnodes for the node ID Check which node did the most recent automatic OCR backup

Posted in Common, RAC | Comments Off on Which node is the OCR master node (AKA “OCR writer”) in a RAC?

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

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

DMU 2.1.1 released

A new version of the “Database Migration Assistant for Unicode” (DMU), was released: DMU 2.1.1. Release 2.1.1 is a maintenance release with some small changes compared to DMU 2.1. DMU 2.1.1 Release Notes: List of changes Download DMU 2.1.1

Posted in Common | Comments Off on DMU 2.1.1 released