Can you create a materialized view on mulitple tables and using aggregates?
I have created the logs on each table with rowid and including new values.

This is the create statement:
1 create materialized view test_sds
2 parallel
3 build immediate
4 refresh fast on commit
5 as
6 SELECT TO_CHAR(BILLPLED_POSTED_DATE,'MM') MONTH,RPAD(AIRLTABL_CODE_ICAO_2, 5) || ' - ' || AIRLTABL_DESCR AIRLINE
7 , SUM(Getledgervalue(AIRLTABL_CODE_ICAO_2
8 , BILLREBT_CODE
9 , BILLPLED_POSTED_DATE
10 , BILLPLED_POSTED_DATE)) VALUE
11 , BILLREBT_GROUP_SUMMARY
12 FROM AIRLTABL, BILLREBT, BILLPLED
13 WHERE AIRLTABL_CODE_ICAO_2 = BILLPLED_OPERATOR
14 ---AND BILLPLED_ACTUAL_DATE BETWEEN datFrom AND datTo
15 AND BILLREBT_GROUP_SUMMARY IS NOT NULL
16 AND BILLPLED_BILLCHGCODE_CODE = BILLREBT_CODE
17 AND BILLPLED_CREDIT > 0
18* GROUP BY TO_CHAR(BILLPLED_POSTED_DATE,'MM'),RPAD(AIRLTABL_CODE_ICAO_2, 5) || ' - ' || AIRLTABL_DESCR,BILLREBT_GROUP_SUMMARY

and this is the error:
FROM AIRLTABL, BILLREBT, BILLPLED
*
ERROR at line 12:
ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized view

If not is this achievable in Oracle 9i?
Thanks.