Take the 2-minute tour ×
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. It's 100% free, no registration required.

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

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

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

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

Your Answer

 
discard

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.