My Oracle Support Banner

ORA-29855 Error Creating APPLSYS FND_LOBS_CTX During Database Import (Doc ID 415117.1)

Last updated on MAY 13, 2023

Applies to:

Oracle Applications DBA - Version to [Release 11.5.10]
Oracle Applications Manager - Version to [Release 11.5.10]
Oracle E-Business Suite Technology Stack - Version to [Release 11.5.10]
Information in this document applies to any platform.


While following:

<Note 230627.1>: "Export/Import Process for Oracle Applications Release 11i Database Instances Using Oracle9i Enterprise Edition" or

<Note 331221.1>: "Export/Import Process for Oracle Applications Release 11i Database Instances Using Oracle Database 10g Enterprise Edition"

...a failure to create the FND LOBS may occur during the import phase on the target database. The reported error will be:

SQL> CREATE INDEX "FND_LOBS_CTX" ON "FND_LOBS" ("FILE_DATA" ) INDEXTYPE IS "CTXSYS"."CONTEXT" PARAMETERS ('lexer APPS.fnd_lobs_gbl_lexer_2 language column language
filter APPS.fnd_lobs_charset_filter_2 format column file_format charset column oracle_charset storage APPS.fnd_lobs_basic_storage_2 wordlist APPS.fnd_lobs_basic_wordlist_2')

ERROR at line 1:
ORA-29855 : error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000 : Oracle Text error:
DRG-10700: preference does not exist: APPS.fnd_lobs_charset_filter_2
ORA-06512 : at "CTXSYS.DRUE", line 157
ORA-06512 : at "CTXSYS.TEXTINDEXMETHODS", line 219

It is very common for this scenario to occur while following <Note 238276.1>: "Migrating to Linux with Oracle Applications Release 11i". An export/import of the database has to take place in order to move the data from one platform to another.


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.