ORA-00979 with Hash Group by on 10.2.04
Hi All,
I have one query which ran successfully on 9.2.0.8 and on 10g it is failing. Please help
Original Query:
SELECT dvm.dvm_sit_id, dvm.dvm_sec_id, dvm.dvm_payable_date,
dvm.dvm_ex_date, dvm.dvm_record_date,
dvm.dvm_income_value_date, dvm.dvm_dividend_type,
dvm.dvm_pct_amt, dvm.dvm_income_ccy, dvm.dvm_income_amt,
dvm.dvm_pool_factor
FROM (SELECT dvm.dvm_sit_id, dvm.dvm_sec_id,
dvm.dvm_payable_date, dvm.dvm_ex_date,
dvm.dvm_record_date, dvm.dvm_seq_no,
dvm.dvm_dividend_type,
MAX (dvm.dvm_dividend_status) dvm_dividend_status
Original Query:
SELECT dvm.dvm_sit_id, dvm.dvm_sec_id, dvm.dvm_payable_date,
dvm.dvm_ex_date, dvm.dvm_record_date,
dvm.dvm_income_value_date, dvm.dvm_dividend_type,
dvm.dvm_pct_amt, dvm.dvm_income_ccy, dvm.dvm_income_amt,
dvm.dvm_pool_factor
FROM (SELECT dvm.dvm_sit_id, dvm.dvm_sec_id,
dvm.dvm_payable_date, dvm.dvm_ex_date,
dvm.dvm_record_date, dvm.dvm_seq_no,
dvm.dvm_dividend_type,
MAX (dvm.dvm_dividend_status) dvm_dividend_status
0