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: exporting to ASCII

Re: exporting to ASCII

From: GDN <gert.deneve_at_advalvas.be>
Date: 18 May 1999 20:32:40 GMT
Message-ID: <01bea16c$c1357ac0$6f11eec3@default>


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@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 Tue May 18 1999 - 15:32:40 CDT

Original text of this message

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