| Max length error while using SQL*Loader [message #355313] |
Thu, 23 October 2008 07:37  |
etl_prasad
Messages: 44
Registered: June 2005
Location: Scotland
|
Member |
|
|
Hi ALL,
i am loading data from ".CSV" file to Oracle table,while i am getting following error even Oracle given max column length.
| Quote: |
Record 4187: Rejected - Error on table SCHEMA.TABLE_NAME, column COLUMN5.
Field in data file exceeds maximum length
|
i checked the max length of the data which is "700" and in Oracle i have taken max length for Varchar2 which is 4000. even though its giving the above error.
can anyone please guide me to solve this..
Thanks in advance.
|
|
|
|
| Re: Max length error while using SQL*Loader [message #355318 is a reply to message #355313] |
Thu, 23 October 2008 07:54  |
etl_prasad
Messages: 44
Registered: June 2005
Location: Scotland
|
Member |
|
|
I have got clue from previous topics,,
actually i tried different options by searching some other topics,, finally i have got the solution,,,
Thanks for this forum,,
Solution: externally i have specified CHAR(4000) at control file and which loaded with out any miss.
 Thanks to all Oracle Gurus
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
