Home » RDBMS Server » Server Utilities » How to loading tab separated,tab delimited datafile with SQLLDR
How to loading tab separated,tab delimited datafile with SQLLDR [message #403421] Fri, 15 May 2009 09:02 Go to next message
nidi_03
Messages: 10
Registered: May 2009
Location: US
Junior Member
Hi,
I need to load some data using SQLLDR. It is a .txt file tab delimited data and the data file may contain tab within column data. Cld anyone suggest how it can be loaded? Thanks.
e.g.
EmpID EmpName EmpAdd1 EmpAdd2
1000 SAM KING SUITE 5 JOHNSON CITY TX
where EmpId = 1000
EmpName SAM KING(tab separated)
EmpAdd1 SUITE 5 JOHNSON CITY (tab separated)
Emp Add2 TX

[Updated on: Fri, 15 May 2009 09:18] by Moderator

Report message to a moderator

Re: How to loading tab separated,tab delimited datafile with SQLLDR [message #403423 is a reply to message #403421] Fri, 15 May 2009 09:20 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Please use CODE tags and properly format the post/sample data.
In control file use

fields terminated by X'09'

Re: How to loading tab separated,tab delimited datafile with SQLLDR [message #403481 is a reply to message #403421] Fri, 15 May 2009 15:42 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8636
Registered: November 2002
Location: California, USA
Senior Member
nidi_03 wrote on Fri, 15 May 2009 07:02

It is a .txt file tab delimited data and the data file may contain tab within column data.



You cannot properly load data where the delimiter is used within the values, unless you have some enclosure characters. You need to obtain your data in a better format, where the delimiter is something that is not used within the column values or where there are enclosing characters such as double quotes.


Re: How to loading tab separated,tab delimited datafile with SQLLDR [message #403784 is a reply to message #403421] Mon, 18 May 2009 12:07 Go to previous message
nidi_03
Messages: 10
Registered: May 2009
Location: US
Junior Member
I guess I need the file in a different format only.Thanks for your replies.
Previous Topic: Impdp with multiple dump file directories
Next Topic: ORA-01406: fetched column value was truncated
Goto Forum:
  


Current Time: Sun Dec 11 02:39:20 CST 2016

Total time taken to generate the page: 0.22012 seconds