patternMinor
Oracle 11gR2 expdp table converted to CSV from Linux
Viewed 0 times
from11gr2csvlinuxoracleexpdptableconverted
Problem
With Oracle expdp, I can export the tables I want with
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?
expdp INCLUDE=TABLE:table1,table2,table3I 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?
Solution
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
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:88212348059
Context
StackExchange Database Administrators Q#13795, answer score: 2
Revisions (0)
No revisions yet.