Domain Index Online Rebuild Issue
Hi,
I was asked to recreate a domain index and thought that I can rebuild it online.
I thought I just can do an -> alter index MYINDEX rebuild online; but it didn't seem to do what I expected.
e.g.
create table mytable(id number primary key, docs clob);
insert into mytable values(111555,'this text will be indexed');
insert into mytable values(111556,'this is a default datastore example');
commit;
create index myindex on mytable(docs)
indextype is ctxsys.context
parameters ('DATASTORE CTXSYS.DEFAULT_DATASTORE');
select index_name, parameters from dba_indexes where index_name = 'MYINDEX';
--MYINDEX DATASTORE CTXSYS.DEFAULT_DATASTORE
alter index MYINDEX rebuild online;
select index_name, parameters from dba_indexes where index_name = 'MYINDEX';
--MYINDEX (parameters colum is empty?)
0