I've done this and it works well.
Steve Orr
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Marin Dimitrov
Sent: Thursday, March 15, 2001 6:43 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Intermedia Domain index and tablespace

 
 
take a look at the "Specifying Storage Attributes" section of
 
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:
 
=======================
create index AAA on BBB.CCC(DDD)

indextype is ctxsys.context

parameters ('filter ctxsys.EEE

            storage FFF');

========================
 
 
 
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. ..."
 

                                Herman Hesse, "Siddhartha"
 
 
 

 
----- Original Message -----
From: andrey
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 INDEX mytab_idx1 ON mytab( bcontent )
INDEXTYPE IS ctxsys.context ;

Thanks a lot in advance .

Reply via email to