Question on MV

  • From: Jay <jaysingh1@xxxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 09 Feb 2004 20:35:40 -0500

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

Other related posts:

  • » Question on MV