Ya...Setelah saya kaji scrip Anda
create materialized view MVW_SLS_MATERIAL
refresh fast on commit
enable query rewrite
as
(select calmonth,cus_ no,material, sum(sales_ amt)sales_ amt
from actual_sales
di situ didefinisikan bahwa Anda menggunakan FAST REFRESH, dalam penggunakan
fast refresh terdapat aturan yaitu harus dibuatkan tabel materialized view log
pada tabel master dan pada site master untuk distribusi data.
Syntax:
CREATE MATERIALIZED VIEW LOG ON [schema.]table options
[PARALLEL int | NOPARALLEL]
Partitioning_options
WITH filter_option(s)
[{INCLUDING|EXCLUDING} NEW VALUES];
--- On Mon, 11/3/08, asupna <[EMAIL PROTECTED]> wrote:
From: asupna <[EMAIL PROTECTED]>
Subject: [indo-oracle] Materialized View refresh tidak berhasil
To: [email protected]
Date: Monday, November 3, 2008, 1:55 AM
Hallo,
saya punya Materialized View yg kalau ditotal dari data table aslinya
tidak sama proses refreshnya gk jalan.
Mohon bantuannya dari rekan2 semua..
mvw yg sy buat
create materialized view MVW_SLS_MATERIAL
refresh fast on commit
enable query rewrite
as
(select calmonth,cus_ no,material, sum(sales_ amt)sales_ amt
from actual_sales
sebelumnya terimakasih atas bantuannya
supriatna
[Non-text portions of this message have been removed]
