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-25287: Invalid value string, string should be non-negative

1 Answers  


NID-00333: Cannot read the header of the following datafiles:

1 Answers  


ORA-29705: ACTIVE_INSTANCE_COUNT is string which is incompatible with the value in other instances

1 Answers  


ORA-27230: OS system call failure

1 Answers  


RMAN-03010: fatal error during library cache pre-loading

1 Answers  






ORA-06124: NETTCP: timeout waiting for ORASRV

1 Answers  


RMAN-08014: channel string: specifying archive log(s) in backup set

1 Answers  


PLS-00413: identifier in CURRENT OF clause is not a cursor name

1 Answers  


NID-00404: DBNEWID - Completed succesfully.

1 Answers  


NID-00120: Database should be mounted exclusively

1 Answers  


PLS-00317: incomplete type "string" was not completed in its declarative region

1 Answers  


NID-00304: Datafile string - reverted

1 Answers  


Categories