ORA-00600 on Materialized View Refresh
Oracle internals for understanding cryptic error messages during materialized view refresh Continue Reading
19c
Create Materialized View is Failing in Oracle 19.13
ORA-00904: invalid identifier when creating materialized view in 19.13 and 19.14. The problem is fixed in 21c. Continue Reading
Compilation Error in 19.14 datapatch
datapatch is failing when migrating from Solaris to Linux Continue Reading
Unexpected Optimizer Statistics Collection
Column usage in predicates can trigger statistics collection even when statistics aren’t stale. The problem got worse in 21c. Continue Reading
ORA-65092 when Updating to Oracle 19.13
Datapatch fails when converting a 19.12 (or lower) non-CDB to 19.13 PDB. Continue Reading
Apex/Data Redaction Conflict
Reports containing SQL expressions with redacted columns will break in versions 18c higher. Worth checking before Apex upgrade. Continue Reading
Improved ORA-04036 Diagnostics in Oracle 19c
Top consumer information included in the incident file. Continue Reading
ORA-07445 in qksqbCheckProp() with Inline Hint
Inline hint can cause ORA-07445 in 18c and 19c. Continue Reading
OR-Expansion of Subqueries – Limitations
How to overcome the limitations of expansion of OR-subqueries in Oracle 19c. Continue Reading
Lateral View Improvement in Oracle 19c
Suboptimal handling of lateral views has improved in Oracle 19c. Continue Reading