Data Conversion from dbname.exp to dbname.dmp

Posted in 2000

Topics: Migration, Import/Export & Data Conversion

Huy Vu — Wed, 2 Feb 2000 21:20:32 -0500 — source: Informix-list mailing list archive (1991-1998)

Hi all, Maybe I'm a stupid in looking for an unexisting tools which allows to do a conversion from Informix export file (dbname.exp for example) to Oracle export file (dbname.dmp for example) but I ask anyway. Thanks in advance for any advise. H.V

↪ replying to Huy Vu

June Tong — Thu, 10 Feb 2000 03:32:40 GMT — source: Informix-list mailing list archive (1991-1998)

Huy Vu wrote: > > Hi all, > > Maybe I'm a stupid in looking for an unexisting tools which allows to do a > conversion from Informix export file (dbname.exp for example) to Oracle > export file (dbname.dmp for example) but I ask anyway. > > Thanks in advance for any advise. > > H.V As far as I know, Oracle's export file is a completely Oracle-proprietary format, therefore you will be unable to convert an Informix export to a .dmp. However, you should be able to use SQLLoad to load the Informix .unl files. Note that the Informix export (dbname.exp) is actually a directory, not a file. This directory contains .unl files, which are pipe-delimited (by default) ASCII data files for each table. June -- june_t@hotmail.com Living on Snickers bars in San Mateo