Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: converting .dmp to .csv

Re: converting .dmp to .csv

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 10 Mar 2006 09:45:52 -0800
Message-ID: <1142012752.726861.20640@p10g2000cwp.googlegroups.com>


I have seen scripts to parse the DDL out of an export file so you should be able to use the same techniques to get the data, but I would not want to tackle the project even if the data did not include long, long raw, or LOB datatypes. I know of no products on the market to do this.

If the source database exists I would just re-extract the data using SQLPlus in csv format.

How do I export a database table to a flat file ?   http://www.jlcomp.demon.co.uk/faq/flatfile.html

HTH -- Mark D Powell -- Received on Fri Mar 10 2006 - 11:45:52 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US