MULTI_COLUMN_DATASTORE
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';