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

LPX-00276: bad HTTP/Mime header

1 Answers

ORA-01274: cannot add datafile 'string' - file could not be created

1 Answers

ORA-30039: Cannot drop the undo tablespace

1 Answers

ORA-38458: invalid operation "string" for XPATH_FILTER_PARAMETERS

1 Answers

ORA-19960: Internal use only

1 Answers

ORA-12853: insufficient memory for PX buffers: current stringK, max needed stringK

1 Answers

ORA-09755: osngpn: port allocation failure.

1 Answers

ORA-27365: job has been notified to stop, but failed to do so immediately

1 Answers

ORA-06318: IPA: Local maximum number of connections exceeded

1 Answers

ORA-12550: TNS:syntax error

1 Answers

ORA-01224: group number in header string does not match GROUP string

1 Answers

ORA-38410: schema extension not allowed for the table name

1 Answers

For more Oracle Errors Interview Questions Click Here