Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> printjoins vs. skipjoins Oracle Text index

printjoins vs. skipjoins Oracle Text index

From: Joe Smith <joe_dba_at_hotmail.com>
Date: Tue, 18 Apr 2006 09:07:58 -0500
Message-ID: <BAY107-F285DEA2091EE8AC048298D97C40@phx.gbl>


If I change this statement in my Oracle Text index creation from skipjoins to printjoins:

begin
  ctx_ddl.set_attribute('mdf_text_lexer_prf', 'skipjoins', '_-'); end;
/

to

begin
  ctx_ddl.set_attribute('mdf_text_lexer_prf', 'printjoins', '_-'); end;
/

Do I have to recreate the table, the Text index or both to make the change permanent?

thanks.



Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Apr 18 2006 - 09:07:58 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US