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. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------