Oracle Text (MOSC)

MOSC Banner

Text index became incorrect after impdp

edited Dec 26, 2014 7:21AM in Oracle Text (MOSC) 5 comments

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;

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