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-16952: Failed to bind this SQL statement.

1 Answers  


ORA-28261: CURRENT_USER can not be used in PLSQL Definer's Right procedure.

1 Answers  


PCC-00106: RELEASE is an Oracle extension to the COMMIT and ROLLBACK statements

1 Answers  


ORA-04003: sequence parameter string exceeds maximum size allowed (string digits)

1 Answers  


ORA-08182: operation not supported while in Flashback mode

1 Answers  






ORA-23472: materialized view "string"."string" must be atomically refreshed

1 Answers  


ORA-16052: DB_UNIQUE_NAME attribute is required

1 Answers  


ORA-16001: database already open for read-only access by another instance

1 Answers  


ORA-01914: invalid auditing option for sequence numbers

1 Answers  


ORA-29358: resource plan string does not exist

1 Answers  


ORA-15000: command disallowed by current instance type

1 Answers  


ORA-09837: addCallback: could not add allocate a callback link.

1 Answers  


Categories