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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: dump to CSV (comma-separated values) file format

RE: dump to CSV (comma-separated values) file format

From: Kevin Closson <kevinc_at_polyserve.com>
Date: Thu, 19 Oct 2006 11:14:21 -0700
Message-ID: <5D2570CAFC98974F9B6A759D1C74BAD001C3328E@ex2.ms.polyserve.com>

        Yeah, the "traditional" (9i) way of external tables is still there in 10g. It depends what access driver you're using to access the table. If you're using sql*loader, you can read from a flat file. If you're using the new datapump driver (which support writing , but afaik no dml) you can write to the file. But then it's a binary file.

nice..thanks for the info guys (and for not RTFMing me :-) )    

Kevin Closson

Blogging at kevinclosson.wordpress.com    

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Oct 19 2006 - 13:14:21 CDT

Original text of this message

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