I'm Reading 11g R2 Oracle® Text Application Developer's Guide, and I'm trying to follow sample code in chapter 9 "Using Oracle Text Name Search". According to comments, file dr0thsnames.txt should be in $ORACLE_HOME/ctx/sample/thes directory, but I can't find it. I'm using Oracle 11 g R2. somebody knows where can I find it?
Thanks in advance.
You need to download the "Oracle Database 11g Release 2 Examples" for your platform, then follow the instructions to install it.
It installs a number of other things that may or may not interest you, but there's no option to install "only" the Text thesaurus, knowledge base, and names files.
Once the Examples are installed, you will still need to follow the instructions to load the thesaurus into your database.
I'm not sure why you don't have it. I have verified that the Examples correctly install the file on 11.2 on Linux x86/64 and on Windows 12.1. I'd be surprised if Windows 11.2 is different.
However to make things easier I've uploaded the file to https://blogs.oracle.com/searchtech/resource/dr0thsnames.txt