replication

Hello,
I need to implement such scheme:
User "A8" in oracle database ver 805 should have snapshot from user "B1_7" table from oracle database "7". Database link should be created from A8 to user B2_7 scheme in oracle database ver. 7.3.4.

A8: select * from snap1;
snap1: create snapshot refresh with rowid as select * from

        B7.table1_at_dblink1;
dblink1: create database link dblink1 connect to user B2_7 identified by magic_word usnig 'ser_name';

B2_7 can do select on B1_7.table,

The problem is: then I call refresh snapshot - I have : SQL> exec dbms_refresh.refresh(name=>'ref'); begin dbms_refresh.refresh(name=>'ref'); end;

*
ERROR at line 1:
ORA-12018: following error encountered during code generation for

           "B1"."snap1"

ORA-00942: table or view does not exist
ORA-02063: preceding line from BPG4
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 386
ORA-06512: at "SYS.DBMS_IREFRESH", line 450
ORA-06512: at "SYS.DBMS_REFRESH", line 182
ORA-06512: at line 1

where 'ref' refresh group on server 8.

When I creat dblink from user A8 to B1_7 ( table owner) all works perfectly well.
Why i cann't go via user B2_7

Thank You.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Jul 10 2000 - 00:00:00 CEST