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
2479 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-00011: no server with name "string" exists

1 Answers

ORA-14324: values being added already exist in DEFAULT partition

1 Answers

ORA-39045: invalid metadata remap name string

1 Answers

ORA-25019: too much concurreny

1 Answers

NNL-00835: Average delete processing time: string

1 Answers

ORA-01097: cannot shutdown while in a transaction - commit or rollback first

1 Answers

ORA-16079: standby archival not enabled

1 Answers

ORA-15182: ASMLIB [string] version mismatch, oracle version [string]

1 Answers

RMAN-06063: DBID is not found in the recovery catalog

1 Answers

ORA-28536: error in processing Heterogeneous Services initialization parameters

1 Answers

NID-00300: Connected to database string (DBID=number)

1 Answers

ORA-01463: cannot modify column datatype with current constraint(s)

1 Answers

For more Oracle Errors Interview Questions Click Here