My Oracle Support Banner

Where to find ctxf102.txt and ctxf102.sql scripts for Post-Upgrade steps from 10gR2 to 11gR2 (Doc ID 1319592.1)

Last updated on APRIL 01, 2020

Applies to:

Oracle Text - Version to [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: to, 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
Step 38

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?


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.