-
Can you create a multiple-table aggregate materialized views
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|