Does Oracle Text (interMedia Text) create theme indexes by default?
That depends on the language – which is determined from the environment variable NLS_LANG. If NLS_LANG is not set, or the language component is set to “American” (e.g. NLS_LANG=”American_America.ISO8859P1), then both theme and word indexes are created automatically. For other language settings, a theme index is not built.