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-03216: Tablespace/Segment Verification cannot proceed

1 Answers  


TNS-00546: control failure

1 Answers  


ORA-19031: XML element or attribute string does not match any in type string.string

1 Answers  


QSM-01029: materialized view, string, is stale in ENFORCED integrity mode

1 Answers  


ORA-01150: cannot prevent writes - file string has online backup set

1 Answers  






RMAN-20401: script already exists

1 Answers  


ORA-29281: invalid mode

1 Answers  


AMD-00135: measure #string: RDBMS measure column data type not specified

1 Answers  


ORA-24802: user defined lob read callback error

1 Answers  


ORA-09975: kxfspini: Error Initializing SDI Process

1 Answers  


SQL*Loader-00476: count of elements for collection is not set or null, 0 will be used

1 Answers  


ORA-07474: snclrd: close error, unable to close sgadef.dbf file.

1 Answers  


Categories