I was contacted by the application developers to check a query which resulted in an ORA-56904 in a 12.1.0.2 Oracle Database. The query used Pivot to select data from a partitioned table which was stored in memory (INMEMORY clause). Without the INMEMORY clause the query was running fine. To recreate the scenario I used the following simplified test-case:…
Read More →