Re: Oracle export to ASCII file?

Create a database link and then select from one table into the other. Or you can use a tool like Infomaker. It has a data pipeline, allowing you to move data between any 2 database systems.

--
Terry Dykstra
Canadian Forest Oil Ltd.
Check out Sybase Developer's Network: http://www.sybase.com/sdn

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

>