-
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.
SQL> ed
Wrote file afiedt.buf
1 begin
2 dbms_repcat.generate_replication_support(sname=>'"DOEOWNER"',
3 oname=>'"DOEPERSONNEL"',
4 type=>'TABLE',
5 min_communication=>TRUE);
6* end;
SQL> /
begin
*
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
172042.1,176913.1,33290.1
-
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 12:48 PM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|