Oracle Text (MOSC)

MOSC Banner

How to index a CLOB column?

edited Oct 20, 2009 3:03AM in Oracle Text (MOSC) 3 commentsAnswered
I have a need to index on a CLOB column.  Initial attempts to index will result in ORA-02373.

In research, I was able to find an that a LOB column could be moved to another tablespace then indexed.

 

So I plan to use these statements (below), to create a text index on CLOB column STATEMENT_TEXT.

Questions:          What storage should be used for the CLOB column?

                                What index type is needed to create a text index on the CLOB column?

 

ALTER TABLE ANY_STATEMENT MOVE

TABLESPACE INFOWH2 STORAGE(INITIAL 4096K)

LOB (STATEMENT_TEXT) STORE lobsegment

(TABLESPACE INFOWH2 STORAGE (INITIAL 4096K

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