Materialized Views - Can't create
From: (wrong string) îÉËÏÌÁÊ çÏÒÏÄÅÊËÉÎ <gnu_at_baltros.ru>
Date: Fri, 13 Jul 2001 12:07:11 +0400
Message-ID: <3b4eadd2_at_ns.baltros.ru>
;
Date: Fri, 13 Jul 2001 12:07:11 +0400
Message-ID: <3b4eadd2_at_ns.baltros.ru>
Hi, all!
Does anybody use materialized views?
I (Oracle 8.1.7/Win2000) can't even create materialized view with fast
refresh on commit. I tried to repeat Oracle's documentation examples, but
unsuccessfull. Remained max pure, the same result:
create materialized view log on schema.table
with rowid;
create materialized view schema.table_mv
refresh fast on commit as
select table.rowid
from table
;
==> ORA-12054: cannot set the ON COMMIT refresh attribute for the
materialized view
What's the matter?
Thanks
Received on Fri Jul 13 2001 - 10:07:11 CEST