CODEWITHSUNDEEP
oracle-databasefiletextsql-loader
Jé Queue
Jé Queue

Reputation: 10637

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.

Upvotes: 0

Views: 8842

Answers (1)

Alex Martelli
Alex Martelli

Reputation: 881645

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

Upvotes: 2

Related Questions