ORA-36180: (XSAGGR08) AGGREGATE cannot function because there is a permission c

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

Question Posted / guest

1 Answers
2650 Views
I also Faced
E-Mail Answers

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

NNL-00918: Time until server restart: string

1 Answers

TNS-03507: Failure looking for ADDRESS keyword

1 Answers

PCC-02301: cannot reopen input file for reading

1 Answers

ORA-36682: (XSDPART20) Partition name string appears twice.

1 Answers

ORA-25465: variable name not specified

1 Answers

ORA-25502: concurrent ALTER SYSTEM QUIESCE/UNQUIESCE command is running

1 Answers

ORA-28102: policy does not exist

1 Answers

DRG-10315: logging is not supported on MTS

1 Answers

EXP-00084: Unexpected DbmsJava error number at step number

1 Answers

ORA-12226: TNS:operating system resource quota exceeded

1 Answers

DGM-16933: Unable to start instance "string".

1 Answers

NNO-00304: listen address string length string exceeds maximum of string

1 Answers

For more Oracle Errors Interview Questions Click Here