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

ORA-36906: (XSAGDNGL45) 4. Model only includes one non-step dimension in the equations.

1 Answers

IMG-00578: missing quantize argument

1 Answers

ORA-01618: redo thread string is not enabled - cannot mount

1 Answers

EXP-00075: rounding FILESIZE down, new value is string

1 Answers

ORA-30175: invalid type given for an argument

1 Answers

ORA-15054: disk "string" does not belong to diskgroup "string"

1 Answers

NNL-00510: Adds a data record to an existing name

1 Answers

ORA-00402: database changes by release string cannot be used by release string

1 Answers

ORA-26082: load of overlapping segments on table string.string is not allowed

0 Answers

ORA-22816: unsupported feature with RETURNING clause

1 Answers

ORA-37082: Invalid percent

1 Answers

TNS-00091: * Navigator (or navgatr) - will ask the Navigator only

1 Answers

For more Oracle Errors Interview Questions Click Here