ORA-30489: Cannot have more than one rollup/cube expression list



ORA-30489: Cannot have more than one rollup/cube expression list..

Answer / guest

Cause: GROUP BY clause has more than one rollup/cube
expression list.

Action: Modify the query such that only one rollup/cube
expressions appear per sub-query.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-14632: cannot specify PARALLEL clause when adding a List subpartition

1 Answers  


ORA-00060: deadlock detected while waiting for resource

1 Answers  


ORA-32033: unsupported column aliasing

3 Answers  


TNS-12688: Login failed: the SecurID server rejected the new pincode

1 Answers  


ORA-29817: non-supported option with disassociate statement

1 Answers  






ORA-08463: overflow converting decimal number to Oracle number

1 Answers  


ORA-01919: role 'string' does not exist

1 Answers  


PLS-00203: function DECODE must be called with at least 3 non-boolean arguments

1 Answers  


ORA-01095: DML statement processed zero rows

1 Answers  


NMP-00009: SNMP initialization failure

1 Answers  


TNS-00296: Stoppable : string

1 Answers  


ORA-09265: spwat: error temporarily suspending process

1 Answers  


Categories