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?
Field in data file exceeds maximum length
Any ideas?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
If you needed more help you should have asked.
ASKER