-
MVIEW on commit refresh condition
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
DONTBSHY
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
|