How do i index a CLOB column in oracle

Posted on 2006-03-29
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, it is taking a lot of time to load the table and it time off everytime.

Any advise or experience in the relavant field.
Question by:GSK_DEV
    1 Comment
    LVL 16

    Accepted Solution

    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 -

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Introduction A previously published article on Experts Exchange ("Joins in Oracle", makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
    How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
    Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now