Re: S: unloader for Oracle

In article <3k9tb9$6qa_at_luxor.mch.sni.de>, helmut_at_d255s271.mch.sni.de (Hr.Kuhn) says:
>
>Hi,
>
>I'm looking for an unloader-utility (SQL*Plus or Pro*C) which is
>able to unload tables from Oracle. I know that there were some
>postings concerning 'unload of a table' in former times, but at
>that time it was not interesting for me. Perhaps somebody outside
>has one or more of these tools that were published some months ago.
>
>Thanks in advance
>Helmut
>--
>Helmut Kuhn Tel: +49 89 636-2887
>Siemens-Nixdorf Informationssysteme AG Fax: +49 89 636-48332
>SNI MR PD 432 email: helmut.kuhn_at_mch.sni.de
>Otto-Hahn-Ring 6
>81739 Muenchen

Helmut,

   I have a generic Pro*C unload utility which unloads a table or view into a variable record format file. It also generates the SQL*Loader control cards needed to load the data into the table.

   You can get the files from TVA's ftp site. The IP address is 152.85.3.3 - anonymous ftp is supported. I think when you come in as an anonymous user you're in the directory /u1/ftp. The directory which contains the unload utility is /u1/ftp/pub/ora_util. The file is unload14.tar. It contains the Pro*C source code (unload.pc), a readme file (unload.readme), and several sample parameter files (sample_unload.*).

Greg Flannery
Database Administration
Tennessee Valley Authority
(615) 751-7810 Received on Thu Mar 23 1995 - 13:58:58 CET