Re: exporting to ASCII

From: Eric <admin_at_t10.net>
Date: Wed, 19 May 1999 15:20:42 -0600
Message-ID: <Pine.BSF.4.05.9905191519250.5066-100000_at_t10.net>


http://www.orafaq.org/faqmain.htm

See the bottom of the faq.

On 18 May 1999, GDN wrote:

> You can write a simple SQL-scripts and execute them in SQL*Plus.
> There you have different options to satisfie your needs :
> spool <filename>
> set pagesize 0
> set linesize <number>
> and others.
>
> Gert
>
> Richard Spelling <richard_at_spellingbusiness.com> wrote in article
> <3741C1AD.A75FB52A_at_spellingbusiness.com>...
> > From what I have read I gather that the exp utilitiy exports to a binary
> > file readable only by
> > the Oracle imp utility (of course)
> >
> > IS there any way to do a database dump to some kind of delimited ASCII
> > file?
> >
> > IS there any aftermarket utilities that will do this?
> > DB is Oracle 5.1.x
> > OS is SV R3.2
> >
> >
> > --
> > Richard
> > Spelling|richard_at_spellingbusiness.com|http://www.spellingbusiness.com
> > SBE Communications, Business Solutions for the next Millennium and
> > Beyond!
> > Boat building projects: http://www.sbecommunications.com/boats/jolla.htm
> >
> >
> >
> >
>
>
Received on Wed May 19 1999 - 23:20:42 CEST

Original text of this message