ORA-30490: Ambiguous expression in GROUP BY ROLLUP or CUBE list



ORA-30490: Ambiguous expression in GROUP BY ROLLUP or CUBE list..

Answer / guest

Cause: An expression in the GROUP BY ROLLUP or CUBE list
matches an expression in the ordinary GROUP BY expression list

Action: Remove the expression from either ordinary GROUP BY
expression list or ROLLUP or CUBE expression list

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-12855: cannot run parallel or insert direct load in a loopback

1 Answers  


ORA-12653: Authentication control function failed

1 Answers  


ORA-33918: (MAKEDCL33) You cannot define a surrogate of dimension workspace object because it is a string.

1 Answers  


ORA-14166: missing INTO keyword

1 Answers  


ORA-15012: ASM file 'string' does not exist

1 Answers  






ORA-07508: scgfal: $deq all unexpected return

1 Answers  


NZE-29105: Cannot export PKCS #12 wallet.

1 Answers  


ORA-14636: only 2 resulting subpartition can be specified for SPLIT SUBPARTITION

1 Answers  


ORA-13220: failed to compare tile with the geometry

1 Answers  


ORA-02280: duplicate or conflicting CYCLE/NOCYCLE specifications

1 Answers  


NNO-00310: server restart countdown aborted

1 Answers  


IMP-00042: CHARSET used, but the export file has specific character set

1 Answers  


Categories