how to create a fulltext index on a virtual column ?
Hello,
I have trouble creating a fulltext index on a virtual column.
Given the following table:
CREATE TABLE "PJCV_ADM"."MANDATAIRE"
(
"CLE_MANDATAIRE" NUMBER CONSTRAINT "NN_366_CLE_MANDATAIRE" NOT NULL ENABLE,
"NOM_MANDATAIRE" VARCHAR2(32 CHAR),
"PRE_MANDATAIRE" VARCHAR2(32 CHAR),
"NOM_PRE_MANDATAIRE" VARCHAR2(65 CHAR) GENERATED ALWAYS AS (DECODE("PRE_MANDATAIRE",NULL,"NOM_MANDATAIRE","NOM_MANDATAIRE"||' '||"PRE_MANDATAIRE")) VIRTUAL VISIBLE NOT NULL ENABLE
)
I would like to create a textual index on NOM_PRE_MANDATAIRE, to be able to perform CONTAINS searches.
I have tried differents ways, with no success, all returning the error:
DRG-11304: function-based indexes are not supported by this indextype
I have trouble creating a fulltext index on a virtual column.
Given the following table:
CREATE TABLE "PJCV_ADM"."MANDATAIRE"
(
"CLE_MANDATAIRE" NUMBER CONSTRAINT "NN_366_CLE_MANDATAIRE" NOT NULL ENABLE,
"NOM_MANDATAIRE" VARCHAR2(32 CHAR),
"PRE_MANDATAIRE" VARCHAR2(32 CHAR),
"NOM_PRE_MANDATAIRE" VARCHAR2(65 CHAR) GENERATED ALWAYS AS (DECODE("PRE_MANDATAIRE",NULL,"NOM_MANDATAIRE","NOM_MANDATAIRE"||' '||"PRE_MANDATAIRE")) VIRTUAL VISIBLE NOT NULL ENABLE
)
I would like to create a textual index on NOM_PRE_MANDATAIRE, to be able to perform CONTAINS searches.
I have tried differents ways, with no success, all returning the error:
DRG-11304: function-based indexes are not supported by this indextype
0