Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Oracle Replication
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);
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