Re: Oracle export to ASCII file?

From: James Hanway <hanwayj_at_NOSPAM.dfo-mpo.gc.ca>
Date: Tue, 07 Mar 2000 16:36:37 GMT
Message-ID: <38C52F2B.213FB1B_at_NOSPAM.dfo-mpo.gc.ca>


Are the two databases on a network at all? If so, why not use SQL*NET and a "create table tab as (select * from table_at_link)...."

James

f wrote:
>
> 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 - 17:36:37 CET

Original text of this message