Home » RDBMS Server » Server Utilities » creating sqlldr control file
creating sqlldr control file [message #73819] Mon, 19 July 2004 05:43 Go to next message
Raquel
Messages: 46
Registered: July 2003
Member
I am trying to load a text file that is tab delimited. What is the code I should type in the control file to specify that the fields are tab delimited?

code from Control file:

load data
infile 'C:temptestswitchingsystemcodes.txt'
into table switching_system_codes
fields terminated by " "
(manufacturer, equip_name, co, pkt)

Report message to a moderator

Re: creating sqlldr control file [message #73820 is a reply to message #73819] Mon, 19 July 2004 06:53 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
[i]
load data
infile 'C:temptestswitchingsystemcodes.txt'
into table switching_system_codes
FIELDS TERMINATED BY X"09"
(manufacturer, equip_name, co, pkt)

Report message to a moderator

Re: creating sqlldr control file [message #74022 is a reply to message #73819] Wed, 25 August 2004 13:51 Go to previous messageGo to next message
Kevin
Messages: 45
Registered: February 2000
Member
I am looking for the samething... What is the correct answer. I don't follow the last reply.

Thanks

Report message to a moderator

Re: creating sqlldr control file [message #74434 is a reply to message #73820] Wed, 08 December 2004 19:52 Go to previous message
Anjoo
Messages: 1
Registered: December 2004
Junior Member
thanks. I was having a similar problem.

Report message to a moderator

Previous Topic: oracle instance being terminated on startup
Next Topic: SQLLDR loading multiple tables
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jul 03 00:56:15 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.