Re: fast refresh 7.3 to 8.0.4 problem

On Mon, 17 Aug 1998 21:55:01 GMT, ronb_at_digitalmarket.com <ronb_at_digitalmarket.com> wrote:
>
>
>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

Are you sure the problem didn't come from the change in ROWID format?

>> 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

--
These opinions are my own and not necessarily those of Information Quest or Pebble In The Sky http://www.informationquest.com mailto:jgarry@nospameiq.com http://ourworld.compuserve.com/homepages/joel_garry Remove nospam to reply. mailto:joel_garry_at_compuserve.nospam.com "See your DBA?" I AM the @#%*& DBA! Received on Mon Aug 17 1998 - 18:51:44 CDT