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
2657 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

NZE-28884: invalid cipher suite

1 Answers

NNF-04007: Error reading input file

1 Answers

ORA-00269: specified log file is part of thread string not string

1 Answers

ORA-12223: TNS:internal limit restriction exceeded

1 Answers

ORA-16595: NetSlave process string failed to terminate

1 Answers

ORA-13120: invalid face_id [string]

1 Answers

ORA-40209: setting % is invalid for % function

1 Answers

DRG-13200: failed to load dictionary file string

1 Answers

ORA-02262: ORA-string occurs while type-checking column default value expression

1 Answers

ORA-06956: Failed to get local host name

1 Answers

NZE-29230: the header length is not sufficient for message header

1 Answers

ORA-31428: no publication contains all the specified columns

1 Answers

For more Oracle Errors Interview Questions Click Here