How do i index a CLOB column in oracle

I have an database table that contain one column that holds a numeric data type. Rest of the columns are CLOB columns.

I am in the processing of migrating the contents of this table into the new database schema which i developed. Since my migration script are written in ASP.net, it is taking a lot of time to load the table and it time off everytime.

Any advise or experience in the relavant field.
LVL 1
GSK_DEVAsked:
Who is Participating?
 
RCorfmanCommented:
In regards to the actual topic question... Oracle does support indexes on clob objects. There is an entire 'subsystem' related to indexing and searching clob columns... Oracle Text.
From the manual...
Oracle Text is a tool that enables you to build text query applications and document classification applications. Oracle Text provides indexing, word and theme searching, and viewing capabilities for text.

There are a few different Oracle text index types. They are documented in the Oracle Text manaul (free, but required registration at Oracle Technology Network - otn.oracle.com)
http://download-west.oracle.com/docs/cd/B10501_01/text.920/a96517/cdefault.htm#1005752

As far as actually loading the data, typically it is better to save the data in files and then use sqlldr to actually do the data load. Loader can be very, very fast.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.