DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Hybrid View

  1. #1
    Join Date
    Jun 2001
    Sri Lanka


    I ceate a Materialized View for content of two table with join.That Mview is a Fast refresh mode.Befor the creation of MView i created two MView log for those two table.when i insert a value for one source table and refresh that change goes to the MView table.Then i created context(CTXSYS) index for one of column of MView table.it's a Varchar2 column.then i insert a value to one source table.when i
    refreshing MView get the following error.why is that pls help

    stack Trace............

    ORA-29876: failed in the execution of the ODCIINDEXDELETE routine
    ORA-20000: InterMedia Text error
    DRG-10602: failed to queue DML change to column for primary key
    DRG-50857: oracle error in drdmlci
    DRG-50858: OCIerror unable to get session handle
    DRG-50858: OCIerror unable to get handles
    ORA-30576: Context option dictionary loading error
    ORA-06512: at "SYS.DBMS_SNAPSHOT",line 604
    ORA-06512: at "SYS.DBMS_SNAPSHOT",line 661
    ORA-06512: at "SYS.DBMS_SNAPSHOT",line 641
    ORA-06512: at line 2

  2. #2
    Join Date
    Oct 2000
    Saskatoon, SK, Canada
    You are hitting the bug 859195. This would not allow you to refresh a snapshot with the contex index created on it. The fix/work around is

    1. Use multimaster replication
    2. Other is drop the context index before the refresh and recreate it after refresh.

    This bug is in existence all the way upto 8.1.7


    Life is a journey, not a destination!

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.