Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Using SQL Loader with large amount of characters in column data

User518407-OCDec 15 2014 — edited Dec 15 2014

Hello,

I am trying to use sql loader but I'm only able to load a certain number of rows before getting this error:

Record 37825: Rejected - Error on table "<SCHEMA>"."<TABLE_NAME>", column COMMENTS.

Field in data file exceeds maximum length

LOAD DATA

INFILE *

BADFILE '<file_path>.bad'

DISCARDFILE '<file_path>.dsc'

APPEND INTO TABLE "<SCHEMA>"."<TABLE_NAME>"

FIELDS TERMINATED BY " "

Trailing nullcols

(RECORD_ID,

MODULE,

OBJECT_NAME,

OBJECT_TYPE,

WEIGHTAGE,

COMMENTS,

ATTRIBUTE1,

ATTRIBUTE2,

ATTRIBUTE3,

TRACK)

BEGINDATA

But I have COMMENTS column defined as CLOB. Does anyone know solution for this? How can I load huge amount of data in this column?

Thank you
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 12 2015
Added on Dec 15 2014
#database-key-features, #export-import-sql-loader-external-tables
5 comments
2,052 views