ORA-36180: (XSAGGR08) AGGREGATE cannot function because
there is a permission clause associated with variable
workspace object.



ORA-36180: (XSAGGR08) AGGREGATE cannot function because there is a permission clause associated wit..

Answer / guest

Cause: When using AGGREGATE, only simple permissions and
permissions on base dimensions are valid.

Action: Remove the permissions clause from the variable
causing problems.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-24960: the attribute string is greater than the maximum allowable length of number

1 Answers  


ORA-24015: cannot create QUEUE_TABLE, QUEUE_PAYLOAD_TYPE string.string does not exist

1 Answers  


RMAN-06115: changed backup piece available

1 Answers  


ORA-13002: specified level is out of range

1 Answers  


NNL-01069: Log file name: string

1 Answers  






NNL-01063: Statistic counters next reset in: string

1 Answers  


ORA-02700: osnoraenv: error translating ORACLE_SID

1 Answers  


ORA-25231: cannot dequeue because CONSUMER_NAME not specified

1 Answers  


ORA-16092: dependent archive log destination is not active

1 Answers  


ORA-27160: process requested to perform operation

1 Answers  


ORA-32811: subscriber string already exists

1 Answers  


AMD-00141: parameter string of "string" not valid starting around "string"

1 Answers  


Categories