Error Refreshing Materialized View
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Error Refreshing Materialized View

Hybrid View

  1. #1
    Join Date
    Jun 2001
    Location
    Sri Lanka
    Posts
    2

    Question

    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 OCI_INVALIED_HANDLE
    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
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    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

    Sam
    Thanx
    Sam



    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