RE: Intermedia Domain index and tablespace

From: Koivu, Lisa <lkoivu_at_qode.com>
Date: Thu, 15 Mar 2001 10:43:40 -0800
Message-ID: <F001.002CD7B0.20010315064246@fatcity.com>

You need
to create preferences and specify them in your create index statement.  This is all in the documentation, by the way.  Also, this does not affect your IOT storage parms.  You will have to modify those separately or you will blow maxextents as your index grows. Here's
what mine look like<SPAN
class=821500013-15032001>
exec
ctxsys.ctx_ddl.create_preference('product_storage','BASIC_STORAGE'); exec
ctxsys.ctx_ddl.set_attribute('product_storage','I_TABLE_CLAUSE','tablespace ctx_idx_a storage (initial 100m next 100m)'); exec
ctxsys.ctx_ddl.set_attribute('product_storage','K_TABLE_CLAUSE','tablespace ctx_idx_a storage (initial 100m next 100m)'); <SPAN
class=821500013-15032001>.....  etc
.........
And
here's how I use it<SPAN
class=821500013-15032001>
create index <SPAN
class=821500013-15032001>x on <SPAN
class=821500013-15032001>q.table(search_string) indextype is
ctxsys.context
parameters (
'lexer product_pref
storage
product_storage
datastore
product_datastore'
)
/
Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL 33319

V: 954.484.3191, x174
F: 954.484.2933 
C: 954.658.5849

http://www.qode.com
 
"The information contained herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com."

  <FONT face=Tahoma
  size=2>-----Original Message-----From: andrey   [mailto:bronfin_at_visualtop.com]Sent: Thursday, March 15, 2001 5:45   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 - 12:43:40 CST