Collection Rebuild Using DATABASE.FULLTEXT Throws Error: DRG-11210: Format Column Must be a Char, Varchar, or Varchar2 Type (Doc ID 887215.1)

Last updated on MAY 01, 2017

Applies to:

Oracle WebCenter Content - Version 10.1.3.3.3 and later
Information in this document applies to any platform.

Symptoms

While performing a collection rebuild using the Repository Manager applet, the following error occurs during the Oracle Text index creation.

!csDbUnableToExecuteSql,CREATE INDEX FT_IdcColl1 ON IdcColl1 (dDocFullText) INDEXTYPE IS CTXSYS.CONTEXT PARAMETERS('DATASTORE CTXSYS.DEFAULT_DATASTORE FILTER CTXSYS.AUTO_FILTER FORMAT COLUMN DFULLTEXTFORMAT CHARSET COLUMN DFULLTEXTCHARSET LEXER OCS_IDCCOLL1_LEXER SYNC (ON COMMIT)')!$ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-11210: format column must be a char\, varchar\, or varchar2 type

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms