get ora23308 when setup updatable snapshot and find ora10980 in trace file

From: mike ding <mding1997_at_mail.net>
Date: Tue, 19 Sep 2000 10:04:16 -0400
Message-Id: <10624.117344@fatcity.com>

Hi, all,

I try to create updatable snapshot under 'mding' when i log as 'repadmin', and get ora23308. After searched the metalink, i turn on sql_trace, and get trace file, find err=10980 in trace file.

---

repadmin_at_rman:tiger.uunet.ca-SQL>begin

  2     dbms_repcat.create_snapshot_repobject(
  3        gname => '"MDING_RG"',
  4        sname => '"MDING"',
  5        oname => '"EMP"',
  6        type => 'SNAPSHOT',
  7        ddl_text => 'create snapshot "MDING"."EMP"  refresh fast with
  8                    primary key for update as select * from
  9                    "MDING"."EMP"@CCO.UUNET.CA ',
 10        min_communication => TRUE);

 11 end;
 12 /
begin
*
ERROR at line 1:

ORA-23308: object MDING.EMP does not exist or is invalid
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 4370
ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 5158
ORA-06512: at "SYS.DBMS_REPCAT_SNA", line 82
ORA-06512: at "SYS.DBMS_REPCAT", line 1076
ORA-06512: at line 2


----------------------------------------------------------------

And in trace file get the following:


----------------------------------------------------------------

PARSE ERROR #28:len=60 dep=2 uid=22 oct=3 lid=22 tim=2443332298 err=10980 select * from

                  "MDING"."EMP"@CCO.UUNET.CA


-----------------------------------------------------------------

I can create updatable snapshot directly logged as 'mding', and then add the snapshot to the snapshot group. but in this way any update to snapshot base table can not pushed back to master site.

If somebody experience this before, please help. Received on Tue Sep 19 2000 - 09:04:16 CDT