SCOTT@orcl_11g> CREATE Table your_table
  2    (col1  VARCHAR2(10),
  3  	col2  VARCHAR2(10),
  4  	col3  VARCHAR2(10))
  5  /

Table created.

SCOTT@orcl_11g> BEGIN
  2    CTX_DDL.CREATE_PREFERENCE ('your_datastore', 'MULTI_COLUMN_DATASTORE');
  3    CTX_DDL.SET_ATTRIBUTE ('your_datastore', 'COLUMNS', 'col1, col2, col3');
  4  END;
  5  /

PL/SQL procedure successfully completed.

SCOTT@orcl_11g> CREATE INDEX your_index ON your_table (col1)
  2  INDEXTYPE IS CTXSYS.CONTEXT
  3  PARAMETERS ('DATASTORE  your_datastore STOPLIST CTXSYS.EMPTY_STOPLIST')
  4  /

Index created.

SCOTT@orcl_11g> select ctx_report.describe_index ('YOUR_INDEX') from dual
  2  /

CTX_REPORT.DESCRIBE_INDEX('YOUR_INDEX')
--------------------------------------------------------------------------------
===========================================================================
                             INDEX DESCRIPTION
===========================================================================
index name:                    "SCOTT"."YOUR_INDEX"
index id:                      4025
index type:                    context

base table:                    "SCOTT"."YOUR_TABLE"
primary key column:
text column:                   COL1
text column type:              VARCHAR2(10)
language column:
format column:
charset column:
Query Stats Enabled:           NO


status:                        INDEXED
full optimize token:
full optimize count:
docid count:                   0
nextid:                        1

===========================================================================
                               INDEX OBJECTS
===========================================================================
datastore:                     MULTI_COLUMN_DATASTORE
   columns:                       col1, col2, col3

filter:                        NULL_FILTER

section group:                 NULL_SECTION_GROUP

lexer:                         BASIC_LEXER

wordlist:                      BASIC_WORDLIST
   stemmer:                       ENGLISH
   fuzzy_match:                   GENERIC

stoplist:                      BASIC_STOPLIST

storage:                       BASIC_STORAGE
   r_table_clause:                lob (data) store as (cache)
   i_index_clause:                compress 2

SCOTT@orcl_11g> select ctx_report.create_index_script ('YOUR_INDEX') from dual
  2  /

CTX_REPORT.CREATE_INDEX_SCRIPT('YOUR_INDEX')
--------------------------------------------------------------------------------
begin
  ctx_ddl.create_preference('"YOUR_INDEX_DST"','MULTI_COLUMN_DATASTORE');
  ctx_ddl.set_attribute('"YOUR_INDEX_DST"','COLUMNS','col1, col2, col3');
end;
/

begin
  ctx_ddl.create_preference('"YOUR_INDEX_FIL"','NULL_FILTER');
end;
/

begin
  ctx_ddl.create_section_group('"YOUR_INDEX_SGP"','NULL_SECTION_GROUP');
end;
/

begin
  ctx_ddl.create_preference('"YOUR_INDEX_LEX"','BASIC_LEXER');
end;
/

begin
  ctx_ddl.create_preference('"YOUR_INDEX_WDL"','BASIC_WORDLIST');
  ctx_ddl.set_attribute('"YOUR_INDEX_WDL"','STEMMER','ENGLISH');
  ctx_ddl.set_attribute('"YOUR_INDEX_WDL"','FUZZY_MATCH','GENERIC');
end;
/

begin
  ctx_ddl.create_stoplist('"YOUR_INDEX_SPL"','BASIC_STOPLIST');
end;
/

begin
  ctx_ddl.create_preference('"YOUR_INDEX_STO"','BASIC_STORAGE');
  ctx_ddl.set_attribute('"YOUR_INDEX_STO"','R_TABLE_CLAUSE','lob (data) store as
 (cache)');
  ctx_ddl.set_attribute('"YOUR_INDEX_STO"','I_INDEX_CLAUSE','compress 2');
end;
/


begin
  ctx_output.start_log('YOUR_INDEX_LOG');
end;
/

create index "SCOTT"."YOUR_INDEX"
  on "SCOTT"."YOUR_TABLE"
      ("COL1")
  indextype is ctxsys.context
  parameters('
    datastore       "YOUR_INDEX_DST"
    filter          "YOUR_INDEX_FIL"
    section group   "YOUR_INDEX_SGP"
    lexer           "YOUR_INDEX_LEX"
    wordlist        "YOUR_INDEX_WDL"
    stoplist        "YOUR_INDEX_SPL"
    storage         "YOUR_INDEX_STO"
  ')
/

begin
  ctx_output.end_log;
end;
/

SCOTT@orcl_11g> select * from ctx_user_index_values where ixv_index_name = 'YOUR_INDEX'
  2  /

IXV_INDEX_NAME                 IXV_CLASS
------------------------------ ------------------------------
IXV_OBJECT                     IXV_ATTRIBUTE
------------------------------ ------------------------------
IXV_VALUE
--------------------------------------------------------------------------------
YOUR_INDEX                     WORDLIST
BASIC_WORDLIST                 STEMMER
ENGLISH

YOUR_INDEX                     WORDLIST
BASIC_WORDLIST                 FUZZY_MATCH
GENERIC

YOUR_INDEX                     DATASTORE
MULTI_COLUMN_DATASTORE         COLUMNS
col1, col2, col3

YOUR_INDEX                     STORAGE
BASIC_STORAGE                  R_TABLE_CLAUSE
lob (data) store as (cache)

YOUR_INDEX                     STORAGE
BASIC_STORAGE                  I_INDEX_CLAUSE
compress 2


SCOTT@orcl_11g> 

SCOTT@orcl_11g> select * from ctx_user_preference_values where prv_preference = 'YOUR_DATASTORE'
  2  /

PRV_PREFERENCE                 PRV_ATTRIBUTE
------------------------------ ------------------------------
PRV_VALUE
--------------------------------------------------------------------------------
YOUR_DATASTORE                 COLUMNS
col1, col2, col3


SCOTT@orcl_11g>