Snapshot replication and schema names

From: Chris Irwin <chrissirwin_at_yahoo.com>
Date: 3 Jun 2004 10:58:05 -0700
Message-ID: <f46814aa.0406030958.651138ac@posting.google.com>

I have updateable snapshot replication setup between one master and one snapshot site. When i have the same schema name on both the master and snapshot site, everything works fine. Then I setup another master site and used different names for the schemas on the master site and snapshot site. When I do this, I get an error when I run the dbms_repcat.create_snapshot_repobject() at the snapshot site. Here is sql I used to create the snapshot and repobject:

CREATE SNAPSHOT addinfo
ON PREBUILT TABLE
USING INDEX TABLESPACE "SYSTEM" PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE( INITIAL 64K NEXT 64K PCTINCREASE 50 MINEXTENTS 1 MAXEXTENTS 2147483645 FREELISTS 1 FREELIST GROUPS 1 ) REFRESH FAST
ON DEMAND
FOR UPDATE
AS
SELECT * FROM archive.addinfo_at_archive.bah.com;

BEGIN
   DBMS_REPCAT.CREATE_SNAPSHOT_REPOBJECT(

      gname => 'archive_MASTER_REP_GROUP',
      sname => 'archive',
      oname => 'ADDINFO',
      type => 'SNAPSHOT',
      min_communication => TRUE);

END; I get the following error when the create_snapshot_repobject executes:

1:42:48 PM ORA-23308: object ARCHIVE.ADDINFO does not exist or is invalid

1:42:48 PM  ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
1:42:48 PM  ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 4378
1:42:48 PM  ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 5166
1:42:48 PM  ORA-06512: at "SYS.DBMS_REPCAT_SNA", line 82
1:42:48 PM  ORA-06512: at "SYS.DBMS_REPCAT", line 1076
1:42:48 PM  ORA-06512: at line 2

So, I guess the question is whether you can use different schema names on the snapshot and master sites?

Any help would be greatly appreciated!

Thanks in advance,

Chris Received on Thu Jun 03 2004 - 12:58:05 CDT