Category Archives: Common
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.
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
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?
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?
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