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 = '12.2.0.1' 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). <<<======= :-(
Is this answer out of date? If it is, please let us know via a Comment