Book: Oracle DBA (Amazon)
Category Archives: Oracle 12c
At the DOAG database conference in May, Andrew Mendelsohn announced that Oracle will change the release schedule to annual releases and that patch naming will be changed to “Release Updates” (RU). The latter started – as announced – in July … Continue reading
It was one of the issues with Oracle 12c Release 1 that datapatch was not executed by dbca automatically. So, if you had installed patches to your Oracle home before running dbca, dbca did not take this into consideration and … Continue reading
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.
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?
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