Re: Oracle Replication

  sname is the owner of the table not 'repadmin'

Kay Liesenfeld <kliesenfeld_at_databecker.de> wrote in article <784tsc$nu4$1_at_goof.de.uu.net>...
> 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