Skip to Main Content
  • Questions
  • View with pivot and group by grouping sets work in 12c but not in 19. Error ORA-56903


Question and Answer

Connor McDonald

Thanks for the question, Ċ½eljko.

Asked: January 29, 2024 - 10:25 am UTC

Last updated: February 27, 2024 - 4:13 am UTC

Version: Oracle 19

Viewed 1000+ times

You Asked

Views with group by grouping sets and pivot directly or in referenced view which worjk in Oracle 12c fall with ORA-56903 error sys_op_pivot function is not allowed here in Oracle 19. Bit in view or referenced view don't have explicit call sys_op_pivot. Mybe Oracle use it during execution of views.
Thanks in advance.
Best regards.

According sugestion I have put:

alter session set optimizer_features_enable = '' but error persists.

It appeare in all view with grouping sets and with pivot clause in subview as base view or directly in current view. If view with pivot clause is subview subview work correctly.

and Connor said...

That sounds like a possible regresion.

What happens if you do

alter session set optimizer_features_enable = {your prev version value]

and then run it?

If that works, then log an SR with Support to get more guidance.

(You didn't give us a test case, so we can't really do much else here). <<<======= :-(

More to Explore


Get all the information about database performance in the Database Performance guide.