interMedia index location (tablespace)

From: Morten <morten_at_kikobu.com>
Date: Wed, 10 Apr 2002 19:46:16 +0200
Message-ID: <3CB47A68.6030806@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 Wed Apr 10 2002 - 12:46:16 CDT