-
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
-
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