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-01192: must have at least one enabled thread

1 Answers  


PCB-00400: %s

1 Answers  


ORA-14043: only one partition may be added

1 Answers  


ORA-13037: SRIDs do not match for the two geometries

1 Answers  


NNO-00608: received corrupted message

1 Answers  






TNS-01019: set rawmode ON | OFF: set output mode for services and status commands

1 Answers  


ORA-10617: Cannot create rollback segment in dictionary managed tablespace

1 Answers  


RMAN-08094: channel string: specifying datafile(s) for proxy restore

1 Answers  


ORA-29950: warning in the execution of ODCIINDEXMERGEPARTITION routine

1 Answers  


ORA-13148: failed to generate SQL filter

1 Answers  


ORA-01543: tablespace 'string' already exists

1 Answers  


ORA-29264: unknown or unsupported URL scheme

1 Answers  


Categories