Re: Snapshot replication and schema names

"Chris Irwin" <chrissirwin_at_yahoo.com> wrote in message news:f46814aa.0406030958.651138ac_at_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

This error would happen if you have not follwed the initial steps of creating a replication environment.

I'm talking about "create replication site" instructions in the replication API manual.

For example: If you forget to grant lock any table to the mat view administrator, you would get this error.

So make sure you RTFM and follow the instructions closely. Relication errors are notorious for being very misleading which makes it harder to debug the real cause.

Anurag Received on Fri Jun 04 2004 - 07:58:06 CDT