Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

With Oracle expdp, I can export the tables I want with

expdp INCLUDE=TABLE:table1,table2,table3

I need a way to convert this into CSV on a linux machine. I've seen Windows tools but don't know how good they are and this needs to work from linux command line/ bash script.

Is this possible?

share|improve this question
How does the file look? (I'm not a dba) Give me a head on one file. – Florin Ghita Feb 24 '12 at 7:59
@FlorinGhita expdp generated files are binary & not human-readable – Phil Apr 4 '12 at 14:09

No its not possible with expdp, you need to use utl_file to solve this

share|improve this answer
Note that the linked discussion goes back some 11 years. The utilities supplied for this purpose have changed over the years. – Walter Mitty Mar 5 '12 at 13:43
You'd be better off using an external table – Phil Apr 4 '12 at 14:09
@Phil he want to write outside the database some tables. How can be useful an external table? Can you write it? – Florin Ghita Apr 4 '12 at 14:16
Actually, I tell a lie. You can't write to external tables. I really shouldn't post on here when sleepy! :) Are you on Windows or Unix? – Phil Apr 4 '12 at 14:22
I'm not the poster. You are really sleepy :)) – Florin Ghita Apr 4 '12 at 14:23

You can also use sqlplus and spool the output. You can find info about the syntax on the internet, searching sqlplus tutorials.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.