Text index became incorrect after impdp
Dear all!
We faced with the following problem: after recovering data from Oracle dump with impdp we found that Oracle Text indexes are incorrect. There are tokens with dots in the service table DR$..$I. As result some full-text queries doesn't work.
We use Oracle 11.2.0.3 for Linux 64x, charset = 'CL8MSWIN1251' (but I guess that for 'UTF-8' I will get the same).
Test Case:
-- Create simple table
CREATE TABLE TEST_TABLE(
ID NUMBER(5) NOT NULL PRIMARY KEY,
TEXT CLOB
);
-- Build default full-text index by field "TEXT"
CREATE INDEX IDX_FTS_TEST ON TEST_TABLE (TEXT) INDEXTYPE IS CTXSYS.CONTEXT;