SCOTT@orcl12c> CREATE TABLE table1
  2    (col1	     VARCHAR2(15),
  3  	col2	     VARCHAR2(15),
  4  	description  VARCHAR2(15))
  5  /

Table created.

SCOTT@orcl12c> INSERT ALL
  2  INTO table1 VALUES ('ale1', 'ale1', 'ale1')
  3  INTO table1 VALUES ('ale2', null, null)
  4  INTO table1 VALUES (null, 'ale3', null)
  5  INTO table1 VALUES ('other', 'data', null)
  6  SELECT * FROM DUAL
  7  /

4 rows created.

SCOTT@orcl12c> CREATE MATERIALIZED VIEW LOG ON table1 WITH ROWID
  2  /

Materialized view log created.

SCOTT@orcl12c> CREATE MATERIALIZED VIEW MV_TEST
  2  NOLOGGING
  3  CACHE
  4  BUILD IMMEDIATE
  5  refresh complete start with (sysdate) next (sysdate+ 5/1440)
  6  with rowid USING TRUSTED CONSTRAINTS
  7  AS
  8  select t1.col1, t1.col2, t1.description
  9  from table1 t1
 10  /

Materialized view created.

SCOTT@orcl12c> begin
  2    ctx_ddl.create_preference ('multicol_inv', 'MULTI_COLUMN_DATASTORE');
  3    ctx_ddl.set_attribute ('multicol_inv', 'columns', 'col1, col2');
  4    ctx_ddl.create_section_group ('auto_trial', 'auto_section_group');
  5  end;
  6  /

PL/SQL procedure successfully completed.

SCOTT@orcl12c> Create index trial_in_ora_index on MV_TEST (description)
  2  indextype is ctxsys.context
  3  parameters ( '
  4  datastore multiCol_inv
  5  section group auto_trial
  6  sync (every "sysdate+(6/1440)")')
  7  /

Index created.

SCOTT@orcl12c> INSERT ALL
  2  INTO table1 VALUES ('ale4', 'ale4', 'ale4')
  3  INTO table1 VALUES ('ale5', null, null)
  4  INTO table1 VALUES (null, 'ale6', null)
  5  INTO table1 VALUES ('something', 'else', null)
  6  SELECT * FROM DUAL
  7  /

4 rows created.

SCOTT@orcl12c> COMMIT
  2  /

Commit complete.

SCOTT@orcl12c> EXEC DBMS_LOCK.SLEEP (420)

PL/SQL procedure successfully completed.

SCOTT@orcl12c> SELECT * FROM mv_test
  2  /

COL1            COL2            DESCRIPTION
--------------- --------------- ---------------
ale1            ale1            ale1
ale2
                ale3
other           data
ale4            ale4            ale4
ale5
                ale6
something       else

8 rows selected.

SCOTT@orcl12c> Select * from MV_TEST where contains(description, '%ale%' ) > 0
  2  /

COL1            COL2            DESCRIPTION
--------------- --------------- ---------------
ale1            ale1            ale1
ale2
                ale3
ale4            ale4            ale4
ale5
                ale6

6 rows selected.

SCOTT@orcl12c> CREATE TABLE table1
  2    (col1	     VARCHAR2(30),
  3  	col2	     VARCHAR2(30),
  4  	description  VARCHAR2(30))
  5  /

Table created.

SCOTT@orcl12c> INSERT ALL
  2  INTO table1 VALUES ('Barbara1', 'Barbara1', 'Barbara1')
  3  INTO table1 VALUES ('Barbara2', null, null)
  4  INTO table1 VALUES (null, 'Barbara3', null)
  5  INTO table1 VALUES ('other', 'data', null)
  6  SELECT * FROM DUAL
  7  /

4 rows created.

SCOTT@orcl12c> CREATE MATERIALIZED VIEW LOG ON table1 WITH ROWID
  2  /

Materialized view log created.

SCOTT@orcl12c> CREATE MATERIALIZED VIEW mv_test
  2  NOLOGGING
  3  CACHE
  4  BUILD IMMEDIATE
  5  refresh fast on commit
  6  with rowid USING TRUSTED CONSTRAINTS
  7  AS
  8  select t1.col1, t1.col2, t1.description
  9  from table1 t1
 10  /

Materialized view created.

SCOTT@orcl12c> begin
  2    ctx_ddl.create_preference ('multicol_inv', 'MULTI_COLUMN_DATASTORE');
  3    ctx_ddl.set_attribute ('multicol_inv', 'columns', 'col1, col2');
  4    ctx_ddl.create_section_group ('auto_trial', 'auto_section_group');
  5  end;
  6  /

PL/SQL procedure successfully completed.

SCOTT@orcl12c> Create index trial_in_ora_index on mv_test (description)
  2  indextype is ctxsys.context
  3  parameters ( '
  4  datastore multiCol_inv
  5  section group auto_trial
  6  sync (on commit)')
  7  /

Index created.

SCOTT@orcl12c> INSERT INTO table1 (col1, col2, description)
  2  SELECT owner, object_name, subobject_name
  3  FROM   all_objects
  4  /

89843 rows created.

SCOTT@orcl12c> INSERT ALL
  2  INTO table1 VALUES ('Barbara4', 'Barbara4', 'Barbara4')
  3  INTO table1 VALUES ('Barbara5', null, null)
  4  INTO table1 VALUES (null, 'Barbara6', null)
  5  INTO table1 VALUES ('something', 'else', null)
  6  SELECT * FROM DUAL
  7  /

4 rows created.

SCOTT@orcl12c> COMMIT
  2  /

Commit complete.

SCOTT@orcl12c> Select * from mv_test where contains(description, 'Barbara%' ) > 0
  2  /

COL1                           COL2                           DESCRIPTION
------------------------------ ------------------------------ ------------------------------
Barbara1                       Barbara1                       Barbara1
Barbara2
                               Barbara3
Barbara4                       Barbara4                       Barbara4
Barbara5
                               Barbara6

6 rows selected.