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 -> Oracle Replication

Oracle Replication

From: Kay Liesenfeld <kliesenfeld_at_databecker.de>
Date: 1999/01/20
Message-ID: <784tsc$nu4$1@goof.de.uu.net>#1/1

I have some trouble with Oracle's replication feature.

There are two tables:

create table tab1 (
col1 number(6),
col2 varchar2(100));

create table tab2 (
col1 number(6) not null,
col2 varchar2(100));

When I try to add these tables to a master group on Oracle Server (7.3.4.) with Oracle Replication Manager (1.3.6.0.1) the following error occur when adding tab2:

begin

    dbms_repcat.generate_replication_support(

      sname => '"REPADMIN"',
      oname => '"TAB2"',
      type => 'TABLE',
      gen_rep2_trigger => FALSE);

end;
ORA-01403: no data found
ORA-06512: at "SYS.DBMS_REPCAT_UTL3", line 1847
ORA-06512: at "SYS.DBMS_REPCAT_UTL3", line 2802
ORA-06512: at "SYS.DBMS_REPCAT_MAS", line 1000
ORA-06512: at "SYS.DBMS_REPCAT", line 176
ORA-06512: at line 2

Tab1 has been added properly. The packages installed for tab2 (TAB2$RP, TAB2$RR) are in invalid state.

My intention is that tables with "not null"-columns and / or primary keys cause this error.

Has anyone some hints to avoid this situation and add tab2 successfully to the master group?

Kay. Received on Wed Jan 20 1999 - 00:00:00 CST

Original text of this message

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