Re: interMedia index location (tablespace)

Run this query:

select table_name, tablespace_name from user_tables where table_name like '%SEAR%';

Morten wrote:
>
> 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

-- 
---------------------------
Thomas Hesse
Systems Support Specialist
Oracle DBA
Xtra Limited
http://www.xtra.co.nz
---------------------------