adv. replication - urgent
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: adv. replication - urgent

  1. #1
    Join Date
    Feb 2003
    Posts
    67

    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.

  2. #2
    Join Date
    May 2001
    Posts
    736
    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.

  3. #3
    Join Date
    May 2001
    Posts
    736
    I found some useful documents for u on Metalink they are

    172042.1,176913.1,33290.1

  4. #4
    Join Date
    Feb 2003
    Posts
    67
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width