Oracle Text (MOSC)

MOSC Banner

migration a text index from oracle 10.2 to 11.2

edited May 21, 2012 3:04AM in Oracle Text (MOSC) 4 commentsAnswered
Hello,

I'm trying to migrate a 10g oracle database to 11.2 on another SUSE Linux 64Bit box.

The application is using oracle text and I have a text index like:

CREATE INDEX JOURNAL.IDX_J_EREIGNIS_TEXT ON JOURNAL.J_EREIGNIS (J_MELDUNG)
INDEXTYPE IS CTXSYS
.CONTEXT
PARAMETERS('SYNC(ON COMMIT) datastore ereignis_meldung_pref lexer german_lexer'
)
NOPARALLEL;

Now my Question:

What's the best way to detect all needed informations for a new text index recreating on the 11.2 SUSE Linux box
like lexer, preferences, wordlist and stoplist?

Thank you very much for all hints.

best regards

Stefan

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