Oracle Text (MOSC)

MOSC Banner

Team, Any one can help on the error : Unable to create Oracle text collection

edited Sep 9, 2019 5:00AM in Oracle Text (MOSC) 4 commentsAnswered

IdcApp: Indexing aborted. Unable to create Oracle text collection 'Text1'. Unable to execute SQL statement 'CREATE INDEX IdcText1 ON Text1 (dDocName)

INDEXTYPE IS CTXSYS.CONTEXT ORDER BY dInDate DESC PARAMETERS('DATASTORE IdcStore_ots1 LEXER IdcLexer_ots1

SECTION GROUP section_group_ots1 MEMORY 20M

FORMAT COLUMN otsFormat CHARSET COLUMN otsCharset

Language COLUMN otsLanguage FILTER CTXSYS.NULL_FILTER

SYNC(MANUAL) ')'. ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine

ORA-20000: Oracle Text error:

DRG-10700: preference does not exist: CTXSYS.NONE_DATATYPE

ORA-06512: at "CTXSYS.DRUE", line 171

ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 316

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center