Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> 8.1.7/ Windows 2000 Replication

8.1.7/ Windows 2000 Replication

From: Sathish Balas <sathishudercor_at_home.com>
Date: Thu, 14 Jun 2001 23:59:05 GMT
Message-ID: <ddcW6.82951$qc.10441573@news1.rdc1.va.home.com>

Adding more info



The object is not owned by replication admin RepAdmin . The replication activity is suspended when i am trying to do this .

"Sathish Balas" <sathishudercor_at_home.com> wrote in message news:iJ9W6.82900$qc.10378275_at_news1.rdc1.va.home.com...
> Any Experts on Replication please help .
>
> I ran catrepr.sql as sys . Then ran catrep.sql as sys user . Then created
> the dblinks and ran other dbms packages
> to set up replication . Replication was successful . Now i am trying to
 add
> some more tables .
> I set up symmetric multimaster replication .
>
> I am trying to generate replication support for this particular table and
 i
> am getting an ora-4042 error .
> This error is for all new tables that i am adding now . I have just shown
 a
> sample .
>
> SQL> /*---
> > generating replication support for table 'TAG_NAME'.
> DOC>---*/
> SQL> begin
> 2 dbms_repcat.generate_replication_support ( sname => 'MID' , oname =>
> 'TAG_NAME' , type => 'TABL
> E' , min_communication => TRUE , generate_80_compatible => FALSE );
> 3 end;
> 4 /
>
> PL/SQL procedure successfully completed.
>
> SQL> r
> 1* select sname , master , oname , request , type , errnum , message
 from
> dba_repcatlog
>
> MID
> MD04.RIC.PMU.COM
> TAG_NAME GENERATE_INTERNAL_PKG_SUPPORT TABLE
> -4042
> ORA-04042: procedure, function, package, or package body does not exist
>
> MID
> MD03.RIC.PMU.COM
> TAG_NAME END_GEN_INTERNAL_PKG_SUPPORT TABLE
>
> TIA
> Sathish .
>
>
Received on Thu Jun 14 2001 - 18:59:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US