Hi,


I need to have an up to date copy of a table in another environment. In the master database I created a materialized view log on the master table:

CREATE MATERIALIZED VIEW LOG ON TIPS.POSITIONS WITH ROWID INCLUDING NEW VALUES;

Actually all applications use a DBLINK to access the positions table in the remote database. I tried to create a snapshot to have better performance:

CREATE MATERIALIZED VIEW MV_POSITIONS
REFRESH FAST ON COMMIT
AS
SELECT *
FROM POSITIONS

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

What are those conditions?

I read in the oracle documentation about on commit refresh:
Restriction: This clause is supported only for materialized join views and single-table materialized aggregate views

Does this mean I can't do a on commit fast refresh on a single table??

Thanks