Home » RDBMS Server » Server Utilities » sqlldr varchar2(800)
sqlldr varchar2(800) [message #69470] Mon, 14 January 2002 03:09 Go to next message
Thierry
Messages: 9
Registered: January 2000
Junior Member
hi
i'm using sqlldr with control file
it's ok
but if my datalength is up to 255, there is a pb

any idea?

thanks
Re: sqlldr varchar2(800) [message #69471 is a reply to message #69470] Mon, 14 January 2002 06:27 Go to previous messageGo to next message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
specify varchar2 datatype in control file.
Re: sqlldr varchar2(800) [message #69708 is a reply to message #69470] Sat, 23 February 2002 00:00 Go to previous message
Manjunath
Messages: 9
Registered: July 2000
Junior Member
In control file specify the length of that string.
For eg.

field1 char(1024)

This will solve ur problem

Regards,
Manjunath (INFOSYS)
Previous Topic: Re: FREE OCP PAPERS
Next Topic: SQLPlus Username and Password
Goto Forum:
  


Current Time: Sat Apr 27 16:17:58 CDT 2024