3

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?

Improve this question
2
  • How does the file look? (I'm not a dba) Give me a head on one file.
    – Florin Ghita
    Commented Feb 24, 2012 at 7:59
  • @FlorinGhita expdp generated files are binary & not human-readable
    – Philᵀᴹ
    Commented Apr 4, 2012 at 14:09

3 Answers 3

Reset to default
2

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

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:88212348059

Improve this answer
5
  • Note that the linked discussion goes back some 11 years. The utilities supplied for this purpose have changed over the years.
    – Walter Mitty
    Commented Mar 5, 2012 at 13:43
  • You'd be better off using an external table
    – Philᵀᴹ
    Commented Apr 4, 2012 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
    Commented Apr 4, 2012 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ᵀᴹ
    Commented Apr 4, 2012 at 14:22
  • I'm not the poster. You are really sleepy :))
    – Florin Ghita
    Commented Apr 4, 2012 at 14:23
0

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

Improve this answer
0

login oracle linux

sqlplus / sysdba

spool "/home/oracle/file.csv";

SELECT * from dual;

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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