3 Replies Latest reply on Aug 2, 2012 10:29 PM by Mark Malakanov (user11181920)

    Basic replication

    919719
      Hello friends,
      when i am created the db link i will run the materialized view but it will not connect.. The following error will occur. What can i do..(I am using oracle 11g R2 standard edition one).


      SQL> create public database link paris connect to repadmin identified by repadmin using 'ROSE';

      Database link created.

      SQL> create materialized view repadmin refresh fast with primary key start with sysdate next sysdate + 1/(24*60)as(select * from repadmin@rose);
      create materialized view repadmin refresh fast with primary key start with sysdate next sysdate + 1/(24*60)as(select * from repadmin@rose)
      *
      ERROR at line 1:
      ORA-00942: table or view does not exist


      SQL> select * from repadmin;
      select * from repadmin
      *
      ERROR at line 1:
      ORA-00942: table or view does not exist


      SQL> conn scott/tiger
      Connected.
      SQL> create materialized view repadmin refresh fast with primary key start with sysdate next sysdate + 1/(24*60)as(select * from repadmin@rose);
      create materialized view repadmin refresh fast with primary key start with sysdate next sysdate + 1/(24*60)as(select * from repadmin@rose)
      *
      ERROR at line 1:
      ORA-04052: error occurred when looking up remote object ANTON.REPADMIN@ROSE
      ORA-00604: error occurred at recursive SQL level 1
      ORA-01017: invalid username/password; logon denied
      ORA-02063: preceding line from ROSE

      Edited by: 916716 on Aug 2, 2012 6:29 AM