(Jagruti Jasleniya) ORA-14652: reference partitioning foreign key is not supported
Tag: Oracle
What is the Latch Event and Why Does It Occur?
(David Fitzjarrell) Posted in an Oracle forum some time back was a question on the latch event:
Not all GROUPING SETS are created equal
(Oren Nakdimon) I’ve just realized, once again, that the Oracle Optimizer is even smarter than I thought. The comments (by Iudith Mentzel and Thomas Mautsch) to my previous post, GROUPING SETS and COLLECT don’t get along, made me understand that not all GROUPING SETS were created equal.
Wipe APEX mail queue
(Jeffrey Kemp) Refreshing any of our non-prod environments (e.g. dev, test, etc.) with a clone from production is a fairly regular process at my client.
Some Query Filtering Examples in ORDS
(Jeff Smith) I said on Twitter yesterday that this was one of my favorite features…
Getting rid of annoying, repetitive messages in /var/log/messages
(Frits Hoogland) The primary source of information regarding any change or issue on a linux system is the /var/log/messages file. I am often annoyed when a linux system is setup in such a way that certain messages are written to syslog with a high frequency swamping the messages file with informatio
How Insert Statement Works
(Shesadev Biswal) When Oracle receives sql/insert query, it requires to run some pre-tasks before actually being able to really run the query.
Database Migration from non-CDB to PDB – The Patch Level Pitfall
(Mike.Dietrich) There are several pitfalls when you plugin a non-CDB into a CDB environment. I’d like to highlight some of them – and show you potential workarounds as well.
Managing API Gateway Costs with Oracle API Platform
(Phil Wilkins) The Oracle API Platform adopted an intelligent pricing model by basing costs on API call volumes and Logical gateway node groupings per hour.
Houston, we’ve got a problem with JSON PUT method
(Flavio Casetta) In brief, in Oracle 12.2.0.1 there is some problem with PUT method of JSON_OBJECT_T, for some reason numbers are not recognized as such, but they are stored as scalar.
