RE: Intermedia Domain index and tablespace

From: Steve Orr <sorr_at_arzoo.com>
Date: Thu, 15 Mar 2001 11:21:45 -0800
Message-ID: <F001.002CDDF2.20010315101557@fatcity.com>

I've
done this and it works well.
Steve
Orr

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

  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><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="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">

• Original Message ----- <DIV style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black">From: <A href="mailto:bronfin_at_visualtop.com" title=bronfin_at_visualtop.com>andrey To: <A href="mailto:ORACLE-L_at_fatcity.com" title=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

    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">.<FONT 
    face="Courier New">context <FONT 
    size=2>;<FONT 
    size=2>Thanks a lot in advance 

    . Received on Thu Mar 15 2001 - 13:21:45 CST