Re: Oracle export to ASCII file?

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

A database link would probably more appropiate but anyway. The problem here most likely is the file needs to be ftp-ed or copied BINARY, otherwise you will get problems with different CR/LF conventions on NT and Linux.

Hth,

Sybrand Bakker, Oracle DBA Received on Tue Mar 07 2000 - 14:18:33 CET