Sign up ×

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

2 Answers 2

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


