My Oracle Support Banner

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 22, 2020

Applies to:

Oracle WebCenter Content - Version 10.0 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

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
Symptoms
Cause
Solution
References

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