Query Throwing Error: ORA-12801: error signaled in parallel query server P002
query is run on a dataguard database that has database link to another database. when query the table thru the database link alone it runs fine however if used with other queries it throws the ORA-12801 error.
this query runs on a dataguard database that throws the ORA-12801 error:
select cse.district_cd,
cse.case_number_id,
cse.case_nm,
cse.case_type_cd,
cse.case_status_cd,
cse.suffix_id,
hbv.SHELTER_TYPE_CD,
hbv.HP_SEASON_END_DT DT,
row_number() over (partition by cse.district_cd, cse.case_number_id, cse.suffix_id order by hbv.HP_SEASON_END_DT desc) rn
from wrt_welfare_case cse,
wrt_heap_budget_vw hbv,
wrt_district_cd dc
where cse.case_type_cd = '60'
and cse.case_status_cd in ('10','21')
and cse.district_cd != '66'
and cse.district_cd = dc.district_cd
and cse.case_number_id = hbv.case_number_id
and hbv.district_cd = dc.district_cd_short_txt
and hbv.shelter_type_cd = '03'
and hbv.HP_SEASON_END_DT between '01-sep-2022' and '30-sep-2022';