Oracle Database Discussions

Hi,

i'm trying to create a materialized view containing references to pl/sql and sysdate in the where clause:

CREATE MATERIALIZED VIEW
foreg_test
build IMMEDIATE
refresh complete on COMMIT
DISABLE QUERY REWRITE
AS
select
CODE,
VALIDITY,
TX,
TN,
TG,
WW
from
foreg
WHERE timestamp_begin in (sysdate);

I know that with that kind of thing, fast refresh of the view isn't possible. My problem is that I can't force Oracle to do a complete refresh with on commit option :(

I always got this error message: ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized view

I've used the package with the table MV_CAPABILITIES_TABLE where the parameter REFRESH_COMPLETE is set to Y if don't use the ON COMMIT option.

Is it possible to use the REFRESH COMPLETE ON COMMIT ?

What' is wrong with my create query ?

Thx !