Replication fast refresh doesn't work on db link? Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: Replication fast refresh doesn't work on db link?

Threaded View

  1. #1
    Join Date
    Oct 2002
    Breda, The Netherlands

    Replication fast refresh doesn't work on db link?


    I have a test-setup for replication : two db's : one production-db and one replication db. Both db's are on the same node, the final setup will be on two nodes. Oracle version:

    I created a snapshot-site and a master site. They are connected via a db-link. I use simple select-statements in the snapshots to read the data:
    SELECT * FROM [schema].[tablename]@[];
    So there are no joins or functions in there.

    After creating snapshots and snapshot logs, I refreshed them with the complete-clause. It works. But the amount of data I have to replicate orders me to refresh with the fast-clause, but this doesn't work.

    I don't receive any ORA's when I run
    - EXECUTE DBMS_MVIEW.REFRESH('[table]','C'); # complete refresh
    - EXECUTE DBMS_MVIEW.REFRESH('[table]','F'); # fast refresh

    A "SELECT MVIEW_NAME,LAST_REFRESH_TYPE,LAST_REFRESH_DATE FROM DBA_MVIEWS" returns "COMPLETE" as refresh type. Even if I refresh fast! Also the date remains the date of yesterday.

    Then: I created a master table, snapshot & snapshot log in one and the same db. And the fast refresh works great!!

    So: the problem lies in the fact that the master table is in a different db? Or because I'm using a db-link?

    I visited Metalink, but there was no sollution. The manual states there are many rules that make the fast refresh impossible, but I don't know what I'm doing wrong here...

    Help would be very appreciated.

    Last edited by efrijters; 06-19-2003 at 06:14 AM.
    An expert is one who knows more and more about less and less until he knows absolutely everything about nothing.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width