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-16081: insufficient number of processes for APPLY

1 Answers  


ORA-38436: attribute set used for an Expression set may not be modified.

1 Answers  


ORA-16195: DG_CONFIG requires DB_UNIQUE_NAME be explicitly defined

1 Answers  


ORA-16550: truncated result

1 Answers  


ORA-27371: jobs of type EXECUTABLE are not supported on this platform

1 Answers  


ORA-01533: cannot rename file 'string'; file does not belong to tablespace

1 Answers  


ORA-22800: invalid user-defined type

1 Answers  


ORA-29319: datafile string is not correct

1 Answers  


ORA-30031: the suspended (resumable) statement has been aborted

1 Answers  


ORA-33024: (XSAGDNGL11) AGGMAP workspace object contains duplicate information.

1 Answers  


ORA-02267: column type incompatible with referenced column type

1 Answers  


ORA-06906: CMX: cannot get maximum packet size from CMX

1 Answers  


Categories