Re: dbms_refresh on 8.1.6 failing

Update on this....
When the snapshot logs are rebuilt on the 8.0.5 Instance, the dbms_utility.refresh can be executed on the 8.1.6 Instance. However, when attempting to run dbms_refresh a second time, it fails with the below message.
If I go back and drop and recreate the snapshot logs on the 8.0.5 Instance, I can again
go to the 8.1.6 instance and run dbms_refresh ONE time only.

bootie wrote:

> We are setting up replication on an Oracle 8.1.6 Database -- Solaris
> 2.7,
> with the replicated data coming from an 8.0.5 Database (where the
> snapshot
> logs are set up)
>
> When executing the refresh package on the 8.1.6 Instance, we are
> receiving
> the following error message:
>
> ORA-12012: error on auto execute of job 33
> ORA-12018: following error encountered during code generation for
> "PROD"."CUSTOMER"
> ORA-00942: table or view does not exist
> ORA-02063: preceding line from PRODDB
> ORA-06512: at "SYS.DBMS_SNAPSHOT", line 604
> ORA-06512: at "SYS.DBMS_SNAPSHOT", line 661
> ORA-06512: at "SYS.DBMS_IREFRESH", line 577
> ORA-06512: at "SYS.DBMS_REFRESH", line 211
> ORA-06512: at line 1
> Sat Jan 20 00:29:43 2001
>
> I am assuming this has to do with either synonyms or permissions (most
> likely permissions) (If I am wrong, please let me know) -- because I can
> go
> in and select from the customer table on both Instances --
>
> However, I am not clear on how the permissions need to be set up. Both
> the
> remote DB (PRODDB) and the local DB have
> the same usernames for the schema needing replication.
>
> We also have public synonyms set up for both sets of tables doing
> replication (there are a total of 8 replicated tables)
> I also notice that in the view dba_synonyms there is a field for db_link
> -
> what is this used for?
>
> Can someone provide some guidance?
>
> TIA
Received on Mon Jan 22 2001 - 13:03:00 CST