We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you a podcast all about Citrix Workspace, moving to the cloud, and analytics & intelligence. Episode 2 coming soon!Listen Now

x

How do i index a CLOB column in oracle

GSK_DEV
GSK_DEV asked
on
Medium Priority
1,028 Views
Last Modified: 2012-05-05
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.
Comment
Watch Question

Commented:
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.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.