RE: Intermedia Domain index and tablespace

From: Jack C. Applewhite <japplewhite_at_inetprofit.com>
Date: Thu, 15 Mar 2001 12:38:15 -0800
Message-ID: <F001.002CD8C6.20010315064301@fatcity.com>

<SPAN

class=515330314-15032001>Andrey,
<SPAN

class=515330314-15032001> 
You're
right in that you cannot explicitly name the tablespace(s) in the Create Index statement.  However, you can put the various (5 or 6 segments in all) pieces of an InterMedia Text index in different tablespaces by creating a Basic_Storage parameter, with suitable attributes.  Your statement below would then have an additional clause such as:
<SPAN

class=515330314-15032001> 
<SPAN

class=515330314-15032001>Parameters ('Datastore CtxSys.My_Direct_Datastore Storage CtxSys.My_Basic_Storage Memory 50000000') ;
<SPAN

class=515330314-15032001> 
That
directs InterMedia to create the index according to the Attributes you define in My_Direct_Datastore and My_Basic_Storage.  The Memory 50000000 part tells InterMedia to use about 50MB of RAM to do the sorting, etc. required to build the index.  Make this as big as you can, since it is the key to fast index creation - that is, if the table is large and already exists.
<SPAN

class=515330314-15032001> 
See
the chapter on Indexing (chapter 3 for Oracle 8.1.6) in the "Oracle8i interMedia Text Reference" for all the details.
<SPAN

class=515330314-15032001> 
Hope
this helps you.
<SPAN

class=515330314-15032001> 
<SPAN

class=515330314-15032001>Jack

--------------------------------Jack C. 

ApplewhiteDatabase Administrator/DeveloperOCP Oracle8 DBAiNetProfit, Inc.Austin,
Texaswww.iNetProfit.comjapplewhite_at_inetprofit.com

  <FONT face=Tahoma
  size=2>-----Original Message-----From: root_at_fatcity.com   [mailto:root_at_fatcity.com]On Behalf Of andreySent: Thursday,   March 15, 2001 4:56 AMTo: Multiple recipients of list   ORACLE-LSubject: Intermedia Domain index and   tablespace   

  Dear list !
  I'm creating an Intermedia
  domain index , and i want to build the index ( and related DR$... tables and   indexes) in a specific tablespace , say IM_TBS .   Although i can not specify the
  TABLESPACE attribute directly , when building a domain index , right   ?
  So , how can i do it
  ?
   
  This is the create index
  statement i use
  CREATE<FONT

  color=#000000 face="Courier New"> <FONT 
  color=#0000f0>INDEX <SPAN 
  class=842495908-15032001>mytab_idx1 <FONT color=#0000f0 

  face="Courier New">ON <FONT
  face="Courier New"><SPAN
  class=842495908-15032001>mytab(
  bcontent )
  INDEXTYPE <FONT
  color=#0000f0 face="Courier New">IS<FONT color=#000000

  face="Courier New"> ctxsys<FONT color=#0000f0 
  face="Courier New">.context <FONT 
  face="Courier New"><SPAN 

  class=842495908-15032001>;<SPAN
  class=842495908-15032001>Thanks a lot in advance   . Received on Thu Mar 15 2001 - 14:38:15 CST