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

LPX-00659: Output write failed.

1 Answers  


KUP-04000: error initializing IO state for file string in string

1 Answers  


ORA-28022: cannot grant external roles to global user or role

1 Answers  


DRG-52105: no delete function found

1 Answers  


ORA-16112: log mining and apply stopping

1 Answers  






TNS-00114: Internal error- Allocation of addresses not performed

1 Answers  


ORA-25109: standby lock name space has illegal character 'string'

1 Answers  


RMAN-06419: file string cannot be proxy restored from handle string

1 Answers  


PLS-00458: subprogram 'string' cannot be called from a REPEATABLE subprogram

1 Answers  


RMAN-08581: channel string: datafile copy complete, elapsed time: string

1 Answers  


ORA-02491: missing required keyword ON or OFF in AUTOEXTEND clause

1 Answers  


ORA-22865: more than one column specified

1 Answers  


Categories