Hi Team,
I have created domain indexon one of the oracle tableas below. I have used USER_DATASTORE while creating index.
BEGIN
ctx_ddl.REMOVE_SECTION ('extract_report_group', 'requesttype');
ctx_ddl.REMOVE_SECTION ('extract_report_group', 'discountcategory');
ctx_ddl.REMOVE_SECTION ('extract_report_group', 'intendeduse');
ctx_ddl.REMOVE_SECTION ('extract_report_group', 'pricelist_i');
ctx_ddl.REMOVE_SECTION ('extract_report_group', 'pricelist_e');
END;
/
-- Drop Section Group
BEGIN
CTX_DDL.DROP_SECTION_GROUP ('extract_report_group');
END;
/
-- Create Section Group
BEGIN
CTX_DDL.CREATE_SECTION_GROUP ('extract_report_group',
'BASIC_SECTION_GROUP');
END;
/
-- Create Sections
BEGIN
ctx_ddl.add_mdata_section ('extract_report_group', 'requesttype', 'rt');
ctx_ddl.add_mdata_section ('extract_report_group','discountcategory','dc');
ctx_ddl.add_mdata_section ('extract_report_group', 'intendeduse', 'iu');
ctx_ddl.add_mdata_section ('extract_report_group', 'pricelist_i', 'pli');
ctx_ddl.add_mdata_section ('extract_report_group', 'pricelist_e', 'ple');
END;
/
-- Drop Preference
BEGIN
CTX_DDL.drop_preference ('extract_report_filter');
END;
/
-- Create Preference
BEGIN
CTX_DDL.CREATE_PREFERENCE ('extract_report_filter', 'USER_DATASTORE');
CTX_DDL.SET_ATTRIBUTE ('extract_report_filter',
'PROCEDURE',
'DOMAIN_INDEX_CREATE_PR');
END;
/
DROP INDEX tab1_IDX1
/
-- Create Domain Index
CREATE INDEX tab1_IDX1
ON tab1 (dummy_col)
INDEXTYPE IS CTXSYS.CONTEXT
PARAMETERS ('stoplist CTXSYS.EMPTY_STOPLIST DATASTORE extract_report_filter section group extract_report_group')
/
-- Sync index
begin
ctx_ddl.sync_index('tab1_IDX1', '2M');
end;
/
When I execute an update statement which updates more than 260 rows I get this error. Can you please help over here.
UPDATE tab1
SET dummy_col = dummy_col
WHERE ROWNUM <= 260;
Erroris
ORA-29877: failed in the execution of the ODCIINDEXUPDATE routine
ORA-20000:
DRG-50857:
ORA-20000: Oracle Text error:initialization failed
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 797
Can you please help over here