Link to home
Start Free TrialLog in
Avatar of mallelaajay
mallelaajay

asked on

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

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?
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mallelaajay
mallelaajay

ASKER

Got it.
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.