Oracle Replication
Date: 1999/01/20
Message-ID: <784tsc$nu4$1_at_goof.de.uu.net>#1/1
[Quoted] 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.) [Quoted] with Oracle Replication Manager (1.3.6.0.1) the following error occur when [Quoted] 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 [Quoted] the master group?
Kay. Received on Wed Jan 20 1999 - 00:00:00 CET