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

TNS-04003: Syntax Error.

1 Answers  


SQL*Loader-00415: column string in table string cannot use and be the object of an SDF or LOBFILE

1 Answers  


NNL-01067: Trace level: number

1 Answers  


RMAN-08182: channel string: validation complete, elapsed time: string

1 Answers  


RMAN-07506: Do you really want to catalog the above files (enter YES or NO)?

1 Answers  






ORA-06779: TLI Driver: error reading ccode

1 Answers  


ORA-02310: exceeded maximum number of allowable columns in table

1 Answers  


ORA-38440: attribute set string does not exist

1 Answers  


ORA-24145: evaluation context string.string already exists

1 Answers  


ORA-06778: TLI Driver: error sending ccode

1 Answers  


ORA-36740: A CHILDLOCK was detected in your valueset

1 Answers  


ORA-06117: NETTCP: unable to create ORASRV: quota exceeded

1 Answers  


Categories