adv. replication - urgent
I am doing multimaster adv. replication in 9.2 on win2000 server using API and everything went well (I have 3 groups and 6 tables) till this command:
Note: DOEPERSONNEL table has a BLOB column.
Wrote file afiedt.buf
ERROR at line 1:
ORA-23308: object DOEOWNER.DOEPERSONNEL does not exist or is invalid
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.DBMS_REPCAT_MAS", line 2906
ORA-06512: at "SYS.DBMS_REPCAT", line 766
ORA-06512: at line 2
I know that in 9.2 we can replicate LOBs and I can describe the table as repadmin user.
Did anyone have this problem? Thanks.
can u check the trace file.As per oracle sometimes the tracefile will give u exactly what is problem presiding above ora-23308.Even in 8i it is possible to have replication using BLOB which iam using in my environment.Some times due tablespace allocation also it may lead this error.
I found some useful documents for u on Metalink they are
Thanks akhadar for the reply.
I did run scritpts to check that table structure, constraints, triggers, tablespaces (for indexes) are same for both databases.
The only discrepancy I see is that there is a difference of 13 rows in the data because they are imported from 803 production servers which we are replacing with 9.2.
Could this be the problem?
Last edited by sureshot; 03-31-2003 at 11:48 AM.
Click Here to Expand Forum to Full Width