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

Report message to a moderator

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.

Report message to a moderator

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)

Report message to a moderator

Previous Topic: Re: FREE OCP PAPERS
Next Topic: SQLPlus Username and Password
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jan 08 18:59:43 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.