Re: Oracle export to ASCII file?

SQL*Plus works for this. You can spool a query result from SQL*Plus to a flat file. SQL*Plus has a number of features to formatting a query output. See SQL*Plus User Guide for details.

Good Luck,
Eugene.

f <frank.wehrle_at_mediaaktiv.de> wrote in message news:38C4FFFA.884FA89A_at_mediaaktiv.de...
> Hi everybody
>
> I'd like to convert some tables of a DB from Oracle 8.1.5i on a Linux
> System to Oracle 7.3 on an NT system.
> I thought I just make an export to an ASCII file that I can import.
> Now there seems to be no way of exporting Data to an ASCII format. Am I
> wrong?
> I read some stuff about oraxcel and so on, the problem is these tools
> seem only to work on NT systems and I don't get a connection from my
> computer (NT) to the Linux DB.
>
> Using the export utility and import on NT brings an error message:
> IMP-00010: Keine gültige Exportdatei, Header konnte nicht verifiziert
> werden
> ==> (Not a valid exportfile, header not verified)
> IMP-00021: Betriebssystemfehler - Fehlercode (dez. 17, hex. Ox11)
> ==>(Operating-System error Errorcode (dez. 17, hex. Ox11) )
> IMP-00000: Der Import-Vorgang endete mit Fehlern
> ==>(Import finished with errors)
>
> Can someone help?
>
> Thanks in advance
> Frank
>
Received on Tue Mar 07 2000 - 15:45:23 CET