tags:

views:

36

answers:

1
Q: 

How to specify tab delimitation file load in Oracle sqlldr control file?

This should be simple, but what is the correct syntax for an Oracle sqlldr control file in order to specify tab delimited/separated data?

FWIW, I found the file was UTF16 and not UTF8, and was editing fine but would introduce null bytes as Oracle read the control file. Can't even replicate today.

+2  A: 

Per this thread, it should be fields terminated by '\t' (don't have an Oracle installation at hand to verify that this is correct).

Alex Martelli  2010-08-20 03:17:31
+1 See documentation at: http://download.oracle.com/docs/cd/E11882_01/server.112/e10701/ldr_concepts.htm#sthref374
Shannon Severance  2010-08-20 03:52:53
Tx Shannon, +1, that reference does indeed give some certainty!-)
Alex Martelli  2010-08-20 04:44:37
I'm wondering if the control file has control characters in there. It is on a Unix box, but \t is not resolving. 11g here. Will report back.
Xepoch  2010-08-23 19:57:22

related questions

Is there a Way to use Linq to Oracle
NHibernate and Oracle connect through Windows Authenication
Boolean Field in Oracle
How do you manage schema upgrades to a production database?
How do I deal with quotes ' in SQL
When do you use table clusters?
Oracle write to file
MS SQL Server 2008 "linked server" to Oracle : schema not showing
Develop on local Oracle instance
Resources for an Oracle beginner
What strategies have you employed to improve web application performance?
Automate Syncing Oracle Tables With MySQL Tables
Best way to encapsulate complex Oracle PL/SQL cursor logic as a view?
What Content Management does your workplace use?
What is the difference between oracle's 'yy' and 'rr' date mask?
SQL/Query tools?
How to make Pro*C cope with #warning directives?
Oracle SQL Developer not responsive when trying to view tables (or suggest an Oracle Mac client)
How big would such a database be?
Oracle - What TNS Names file am I using?
What is a good way to open large files across a WAN?
How do I find the high water mark (for sessions) on Oracle 9i
SQL Case Statement Syntax?
cx_Oracle - what is the best way to iterate over a result set?
cx_Oracle - How do I access Oracle from Python?