Replication API: ORA-23308

From: Xyerp <Xyerp_at_hotmail.com>
Date: 22 Aug 2002 05:30:02 -0700
Message-ID: <3d7bc779.0208220430.1986fea7@posting.google.com>

Hi,

I have two master databases - TEST0.WORLD & TEST1.WORLD. I am working on TEST0.WORLD here...

I'm trying to create a master group on Oracle 8.1.5, but after issuing the following API call:

BEGIN
    DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT (

      sname => 'SCOTT',
      oname => 'EMP', 
      type => 'TABLE',
      min_communication => TRUE); 

END;
/

and checking the repcatlog using:

SELECT * FROM dba_repcatlog WHERE gname = 'SCOTT_MG';

I am told that:

ORA-23308: object SCOTT.EMP does not exist or is invalid

If I do:

select * from dba_repobject;

All objects are given a VALID status.

The object was created using:

BEGIN
   DBMS_REPCAT.CREATE_MASTER_REPOBJECT (

      gname => 'SCOTT_MG',
      type => 'TABLE',
      oname => 'EMP',
      sname => 'SCOTT',
      use_existing_object => TRUE,
      copy_rows => TRUE);

END;
/

Everything looks good, so why the ORA-23308?

Thanks in advance!

Russell Packer Received on Thu Aug 22 2002 - 07:30:02 CDT