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: ASCII Data Export

Re: ASCII Data Export

From: Rich Woods <rawoods_at_concentric.net>
Date: 1996/12/18
Message-ID: <32B896AF.2C6F@concentric.net>#1/1

Brenda Muller wrote:
>
> Hi,
>
> I just need to export some data from an Oracle DB into a flat file,
> delimited by something or other (doesn't really matter). What's the
> *best* way to do this (easiest, quickest)?
>
> This is an older version of Oracle... 7.0.13... running on HP-UX 9.1
>
> Thanks!
> --
> Brenda S. Muller
> Sr. Consultant, Miaco Corporation / U S West
>
> "Water yields, yet is able to wear down rocks and stone.
> The gentle wears out the hard. The easy outlasts the
> difficult. All people know this, yet few practice gentleness."
>
> - from "The Tao of Women"
Brenda,

The quickest way is to use SQL*Plus. Between the various Set options and select list syntax, you can easily put together your dump utility.

-- 
Rich Woods
Technical Field Support Specialist, Oracle Corporation, USA
The above statements and opinions are my own and do not
necessarily represent those of Oracle Corporation.
Received on Wed Dec 18 1996 - 00:00:00 CST

Original text of this message

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