Re: Intermedia Domain index and tablespace

From: Marin Dimitrov <marin_at_sirma.bg>
Date: Thu, 15 Mar 2001 10:28:16 -0800
Message-ID: <F001.002CD77F.20010315064242@fatcity.com>

 
 

take a look at the "Specifying
Storage Attributes" section of
<A
href="http://technet.oracle.com/doc/inter.815/a67843/cddlpkg.htm#16740">http://technet.oracle.com/doc/inter.815/a67843/cddlpkg.htm#16740
 

there is an example for creating a storage preference for the index and assigning different components of the domain index to different tablespaces.
 

after u have set the preferences up u'll have to create the index with something like:
 

=======================<FONT face="Courier New" 

size=2>create index AAA on BBB.CCC(DDD)

indextype is ctxsys.context
parameters ('filter ctxsys.EEE
           

storage FFF');
<FONT

size=2><FONT 
size=2><FONT 
size=2><FONT 
size=2>========================

 
 
 

hth,
 
    Marin

----"When someone is seeking, it happens quite easily that he only sees the thing that he is seeking; that he is unable to find anything, unable to absorb anything, because he is only thinking of the thing he is seeking,because he is obsessed with his goal. Seeking means: to have a goal; but finding means: to be free, to be receptive, to have no goal. ..."
 

<FONT

size=2>                                

Herman Hesse, "Siddhartha"
 
 
 
 

<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

• Original Message ----- <DIV style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: andrey

  To: <A title=ORACLE-L_at_fatcity.com
  href="mailto:ORACLE-L_at_fatcity.com">Multiple recipients of list ORACLE-L   

  Sent: Thursday, March 15, 2001
12:55
  Subject: 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
  face="Courier New" color=#000000> <FONT

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

  face="Courier New"><SPAN
  class=842495908-15032001>mytab(
  bcontent )
  INDEXTYPE <FONT
  face="Courier New" color=#0000f0>IS<FONT face="Courier New"   color=#000000> ctxsys<FONT face="Courier New"   color=#0000f0>.context <FONT
  face="Courier New"><SPAN
  class=842495908-15032001>;<SPAN
  class=842495908-15032001>Thanks a lot in advance   . Received on Thu Mar 15 2001 - 12:28:16 CST