Skip to Main Content
  • Questions

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

Breadcrumb

XMAS_TREE

The AskTOM team is taking a break over the holiday season, so we're not taking questions or responding to comments. Please have a happy and safe festive season and as always, thanks for being a member of the AskTOM community.

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 = '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). <<<======= :-(

We're not taking comments currently, so please try again later if you want to add a comment.
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Performance

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