I was getting the following error while trying to create a domain index in a database while it worked fine in another database. I did try recreating the index after dropping it and the issue still persisted until the DBA "reinstalled" the Oracle Text component (don't know what that means though).
CREATE INDEX whs_base_ft_ix ON whs_base_t(title)
INDEXTYPE IS CTXSYS.CONTEXT PARAMETERS
('storage whs_base_storage datastore whs_base_datastore section group whs_base_section_group sync (on commit)')
Error report -
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 183
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 320
29855. 00000 - "error occurred in the execution of ODCIINDEXCREATE routine"
*Cause: Failed to successfully execute the ODCIIndexCreate routine.
*Action: Check to see if the routine has been coded correctly.
Version for both DBs are: "Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production Version 18.8.0.0.0"
While searching, came across another post which had a similar error but for another preference. What I am interested in is, how do I query to find out the collection of these preferences from CTXSYS as a currently logged user who is not a dba.