Re: multimaster replication

From: <mike7411_at_gmail.com>
Date: 14 Sep 2006 13:27:48 -0700
Message-ID: <1158265667.980041.51970@p79g2000cwp.googlegroups.com>

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0

SQL> BEGIN

  2      DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT (
  3        sname => 'sys',
  4        oname => 'miketbl',
  5        type => 'TABLE',
  6        min_communication => TRUE);

  7 END;
  8 /

ERROR at line 1:

ORA-23308: object SYS.MIKETBL does not exist or is invalid
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_REPCAT_MAS", line 2906
ORA-06512: at "SYS.DBMS_REPCAT", line 766
ORA-06512: at line 2

Sybrand Bakker wrote:
> On 14 Sep 2006 10:25:15 -0700, mike7411_at_gmail.com wrote:
>
> >I tried following the directions in the Oracle Database Advanced
> >Replication Management API Reference to configure multimaster
> >replication with the HR sample schema. It seems to work.
> >
> >However, when I try to replicate my own table, it never works. I
> >created a table as follows:
> >
> >NAME VARCHAR2(80)
> >PASS VARCHAR2(80)
> >
> >I set NAME as the primary key.
> >
> >When I try to replicate it, Oracle keeps saying my object does not
> >exist or is invalid.
> >
> >Any ideas?
> >
> >Thanks.
>
> Yes.
> You won't get any valid responses, as you don't specify
> your Oracle version up to 5 digits
> the exact error message
> the exact command you were using.
> Apart from that for any version greater than 8i Advanced Replication
> has been superseded by Streams.
>
> --
> Sybrand Bakker, Senior Oracle DBA
Received on Thu Sep 14 2006 - 15:27:48 CDT