interMedia Text index itself is not stored anywhere (just its DDL, which goes
into SYSTEM), it takes no space. DR$ tables and indexes is what this 'index'
actually consists of, and these are allocated as per your preference (or in
user's default tablespace if you didn't specify and storage preference). Read
the interMedia Text reference for more details on these DR$ tables and their
indexes.
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
"Morten" <morten_at_kikobu.com> wrote in message news:3CB47A68.6030806_at_kikobu.com...
>
> Hi. Oracle 8.1.7.0.
>
> exec ctx_ddl.create_preference('index_location','BASIC_STORAGE');
> exec ctx_ddl.set_attribute('index_location','I_TABLE_CLAUSE','tablespace
> tbls01');
>
> CREATE INDEX ccs_search_index
> ON ccs_search(content)
> INDEXTYPE IS ctxsys.context
> PARAMETERS('section group ccs_search_group storage index_location');
>
> SQL> select index_name, tablespace_name from user_indexes where
> index_name like '%SEAR%';
>
> INDEX_NAME
> TABLESPACE_NAME
> ------------------------------ ------------------------------
> CCS_SEARCH_INDEX
> SYSTEM
> DR$CCS_SEARCH_INDEX$X
> TBLS01
>
> Can any of you explain the result of the above query to me?
> Thanks,
>
> Morten
>
Received on Thu Apr 11 2002 - 06:19:11 CDT
