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

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to dump tables to text file from SQLPLUS

Re: How to dump tables to text file from SQLPLUS

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Thu, 20 Jan 2000 11:16:33 -0500
Message-ID: <q6de8ssmkr0o3jqc527jcdg2nqhc8h9ipi@4ax.com>


A copy of this was sent to Lou Leclerc
<louis_s_leclercNOloSPAM_at_yahoo.com.invalid> (if that email address didn't require changing) On Wed, 19 Jan 2000 23:12:21 -0800, you wrote:

>
>In Ingres there is a command in their sql interpreter called
>"copy", that makes straight text dumps of tables into a file system
>text file.
>
>Is there a similar way to do this in the oracle environment SQLPLUS
>as it does not seem to be evident from the manuals.
>

see http://osi.oracle.com/~tkyte/flat/index.html

>Thank You;
>
>Lou Leclerc
>
>
>
>* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
>The fastest and easiest way to search and participate in Usenet - Free!

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Jan 20 2000 - 10:16:33 CST

Original text of this message

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