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>
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