Where to find ctxf102.txt and ctxf102.sql scripts for Post-Upgrade steps from 10gR2 to 11gR2
Last updated on SEPTEMBER 30, 2014
Applies to:Oracle Text - Version 10.2.0.1 to 220.127.116.11 [Release 10.2 to 11.2]
Information in this document applies to any platform.
In preparation of upgrading the database from 10gR2 to 11gR2, for example: 10.2.0.4 to 18.104.22.168, using note: Complete Checklist for Manual Upgrades to 11gR2 (Doc ID 837570.1).
Questions regarding this section of the <Note 837570.1> :
Post Upgrade Steps
Upgrading Oracle Text
This is only needed if Oracle Text is in use .
Copy the following files from the previous Oracle home to the new Oracle home:
* Stemming user-dictionary files
* User-modified KOREAN_MORPH_LEXER dictionary files
* USER_FILTER executables
To obtain a list of the above files, use:
where version is 920,101,102
For instance, if upgrading from 10.2.0
1. For User Extended Knowledge Base files check
2. Execute the script as database user SYS,SYSTEM, or CTXSYS
If your Oracle Text index uses KOREAN_LEXER which was deprecated in Oracle 9i and desupported in Oracle 10g Release 2, see below Note for further information on manual migration from KOREAN_LEXER to KOREAN_MORPH_LEXER.
<Note 300172.1> Obsolescence of KOREAN_LEXER Lexer Type
When I check my database server, in the $ORACLE_HOME/ctx/admin directory, I do not find the ctxf102.* files. I only have the ctxf101.* files.
Why don't I have the files mentioned in the note?
Also, we are not using KOREAN_LEXER., so do I need to worry about the step listed for KOREAN_LEXER?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms