Re: Exporting ascii files

From: Jeff Stander <jstander_at_ml.csiro.au>
Date: Tue, 28 Sep 1993 23:05:55 GMT
Message-ID: <1993Sep28.230555.2337_at_ml.csiro.au>


In article UgdjujG00VBKAPqVIN_at_andrew.cmu.edu, Serge Taylor <st0u+_at_andrew.cmu.edu> () writes:
>I'm new to Oracle and may have missed something
>in the documentation of the Export facility, but I cannot
>figure out how to export data from a table in ascii format
>(rather than oracle binary), with control over the kind of
>deliminter between fields (blank space is preferred).
>I need a file with only the data, one row per line, in ascii,
>separated by a space.
>Is there some easy way to do this?
>Thanks,
>Serge Taylor

I have written an oraperl program to do just this. It is available via anonymous ftp:

	host:	aqueous.ml.csiro.au
	IP:	192.67.12.100
	dir:	/pub/jstander/oracle_utilities
        files:  unloadr unloadr.1

Hope it works for you.

---
___________________________________________________________________________

Jeff.Stander_at_ml.csiro.au        _--_|\        Database Analyst
CSIRO Division Of Fisheries    /      \       Pelagic Fisheries Resources
GPO Box 1538, Hobart           \_.--._/       Tasmania 7001, Australia
Aus Tel: 002-325-332                 v        Intl Tel: +61-02-325-332
Aus Fax: 002-325-000                          Intl Fax: +61-02-325-000
___________________________________________________________________________
Received on Wed Sep 29 1993 - 00:05:55 CET

Original text of this message