Query Failed 9134 intermediate aggregate storage limit for XMLAgg has been exceeded during computati

Database

Query Failed 9134 intermediate aggregate storage limit for XMLAgg has been exceeded during computati

Hi,

 

By using below query i anm getting error"Query Failed 9134 intermediate aggregate storage limit for XMLAgg has been exceeded during computation"

 

select a.Pid ,Count(a.Emp_ID),
TRIM(TRAILING ',' FROM (XMLAGG(TRIM(b.Skill_cd)|| ',' ORDER BY a.unique_id) (VARCHAR(10000)))) as Skill_cd
from XYZ.EMP a,  XYZ.EMP_SKILL b 
where a.unique_id=b.unique_id 
and 
a.SEQ_NBR=b.SEQ_NBR
group by 1;

Please suggest.

 

Thanks,

Satya