MULTI_COLUMN_DATASTORE

SELECT owner, pref_name, pref_type

FROM ctx_sys_preferences

WHERE pref_type = 'MULTI_COLUMN_DATASTORE';

SELECT pref_name, pref_type

FROM ctx_user_preferences

WHERE pref_type = 'MULTI_COLUMN_DATASTORE';

BEGIN

  CTX_DDL.SET_ATTRIBUTE('your_datastore_name', 'COLUMNS', 'existing_columns, new_column');

END;

BEGIN

  CTX_DDL.SYNC_INDEX('your_index_name', '2M');

END;

SELECT object_name, object_type, last_ddl_time

FROM user_objects

WHERE object_name = 'your_index_name' AND object_type = 'INDEX';