Home » SQL & PL/SQL » SQL & PL/SQL » oracle external table load (oracle 11g)
oracle external table load [message #664518] Thu, 20 July 2017 12:07 Go to next message
Messages: 36
Registered: April 2017
hi team,

I have a txt file which is in tab delimited file i want to load the file into database using oracle external table . I am using the below piece in my code but its not working can any one has a solution ?

"Feilds seperated by 'char(9) "

Re: oracle external table load [message #664520 is a reply to message #664518] Thu, 20 July 2017 12:09 Go to previous messageGo to next message
Bill B
Messages: 1722
Registered: December 2004
Senior Member
that's because it's not Feilds seperated by 'char(9)), its


[Updated on: Thu, 20 July 2017 12:12]

Report message to a moderator

Re: oracle external table load [message #664579 is a reply to message #664520] Sun, 23 July 2017 19:09 Go to previous message
Barbara Boehmer
Messages: 8813
Registered: November 2002
Location: California, USA
Senior Member
Tab delimited is x'9' not char(9), so it should be:

Previous Topic: utl_file issue
Next Topic: foreign key conflict issue
Goto Forum:

Current Time: Tue Mar 20 09:54:24 CDT 2018

Total time taken to generate the page: 0.02303 seconds