Category: Pivot

ORA-56904 when using Pivot with partitioned tables and Oracle Database In-Memory
By: Date: April 15, 2016 Categories: ORA-56904,Oracle,Oracle Database In-Memory,Pivot

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 →