Re: TABLE DATA -> ASCII ?

In article 8oq_at_netcom.com, jdennis_at_netcom.com (John Dennis) writes:
>
>I'm trying to export data from a table into a standard
>ASCII format like tab or "|" delimited. I hope to put this output
>into a SQL loader script to load data at another site. I know
>that I can use EXP and IMPORT but I'd perfer not to unless, of course,
>EXP with write out the data in ASCII format :-O
>
>Any ideas?
>
>John Dennis
>

John, I have written a utility in Perl to do just that, called 'unloadr'.

You can get it, along with some other stuff, via anonymous ftp from

	host:	ftp.ml.csiro.au
	IP:	192.67.12.100
	dir:	/pub/jstander/oracle_utilities

Jeff

---
___________________________________________________________________________

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
___________________________________________________________________________