Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Question on MV
Dear All,
1)create index emp_domain_ind on employees(resume) indextype is ctxsys.context;
2)create index DR$EMP_DOMAIN_IND$X on
DR$EMP_DOMAIN_IND$I(TOKEN_TEXT,TOKEN_TYPE,TOKEN_FIRST,TOKEN_LAST,TOKEN_COUNT
);
When I create Intermedia index(using step-1) , DR$EMP_DOMAIN_IND$X will be created automatically. Isn't it?
One of my co-workwer send me the script to perform both step(1) and step(2). What could be the reason?.
Could someone enlighten me on this?
Thanks
Jay.
![]() |
![]() |