Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 8.1.7/ Windows 2000 Replication
Adding more info
"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