?
Solved

How to load CLOB data into oracle table using sql loader?

Posted on 2011-10-31
3
Medium Priority
?
4,680 Views
Last Modified: 2013-11-11
I have a table with 60 colums out of which the last column is a CLOB datatype, and the table has around 100 thousand rows. I need to extract it and load into a different table using sql loader. But, when i try its throwing me an error on last column saying below

Field in data file exceeds maximum length

Any ideas?
0
Comment
Question by:mallelaajay
  • 2
3 Comments
 
LVL 78

Accepted Solution

by:
slightwv (䄆 Netminder) earned 1500 total points
ID: 37058775
There are a LOT of articles out there on loading CLOBs with SQL Loader.

First two Google hits:

http://www.oracle-base.com/articles/10g/LoadLobDataUsingSqlLoader.php
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:627223659651


If you have problems please post any errors and your sqlldr control file and some sample data if you can.
0
 

Author Closing Comment

by:mallelaajay
ID: 37069325
Got it.
0
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 37069452
Any reason for the 'B' grade penalty?  A 'B' means you didn't get a complete answer.
If you needed more help you should have asked.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
Suggested Courses
Course of the Month15 days, 6 hours left to enroll

840 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