Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error when importing Oracle Text: missing pref

DannyS-OracleMar 5 2018 — edited Mar 6 2018

Hi every one,

I am trying to separate my Apex dev and prod environments. Upon importing my exported application and supporting objects file into the new workspace, I got error related to Oracle Text preference:

ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-10700: preference does not exist: MDT_MULTI

Preference MDT_MULTI is created to tell my index that I am using a multi column data store. How to create the DDL statements for preference and lexer? I tried to manually write some statements inside my DDL script, but I still got the same error ...

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 3 2018
Added on Mar 5 2018
#apex, #database-key-features, #import, #text
2 comments
250 views