Re: fast refresh 7.3 to 8.0.4 problem

I solved my own problem, but in case anyone else runs into this, here is what happened (you can have this info for free...I love you all)

There must be a bug in the procedure dbms_refresh.refresh because a complete refresh works but a fast refresh does not. I had received all the solutions for the ORA-12004 message from support, but none of them worked. The last suggestion they sent me did point me in the right direction.

The snapshot must be owned by the same account name as the snapshot log. I had the snapshot log on the 7.3.3 master database being owned by 'ACCOUNT1' but on the replication database (8.0.4) I created the snapshot in account 'ACCOUNT2'. Although a complete refresh will work, a fast refresh will not. Although the db link is pointing to the correct account on the master database, the dbms_refresh.refresh procedure was looking for the snapshot log in ACCOUNT2 on the master database i.e. ACCOUNT2.MLOG$_tablename

Ron Bogdanoff

In article <6r9p6m$2ea$1_at_nnrp1.dejanews.com>,   ronb_at_digitalmarket.com wrote:
> Here is my problem.
>
> I have a master database on 7.3.3 and a snapshot of a table from that database
> in a 8.0.4 database.
>
> I created the snapshot log with no problems and it is working fine.
>
> I created the snapshot with 'refresh fast' and 'with ROWID'. This initial
> create works (because it is a complete refresh) but when I do 'exec
> dbms_refresh.refresh(....)' I get ORA-12004 Cannot do a FAST REFRESH ....
>
> Any suggestions on why I get this error message?
>
> Thanks
>
> Ron Bogdanoff
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Mon Aug 17 1998 - 16:55:01 CDT