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?

  • How does the file look? (I'm not a dba) Give me a head on one file. 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


  • Note that the linked discussion goes back some 11 years. The utilities supplied for this purpose have changed over the years. 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? 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 :)) 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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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