dbms_refresh on 8.1.6 failing

From: bootie <bootie_at_yahoo.com>
Date: Sun, 21 Jan 2001 17:56:07 -0800
Message-ID: <3A6B9337.77B30E9C@yahoo.com>

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 Sun Jan 21 2001 - 19:56:07 CST