Re: Oracle8 Exp/Imp question

From: Piotr Kolodziej <pkol_at_otago.gda.pl>
Date: Mon, 25 May 1998 19:04:31 +0200
Message-ID: <6kc8b4$mul$1@sunrise.pg.gda.pl>

Don wrote in message <35699e06.44854393_at_news.earthlink.net>...
>Is it possible to do a table export from Oracle8 (NT 4.0) and use that
>EXPORT.DMP then do an import into Oracle 7.3.3 (win95)?
>
>I've used the EXP80 provided in Ora8 to create the EXPORT.DMP file.
>During the import, using imp73.exe, I keep getting IMP-00010 "not a
>valid export file, header failed verification" message on the V7.3.3
>side.
>
>When I look at the EXPORT.DMP file in a hex editor, I immediately see
>that the first line contains the version stamp of the database from
>which the export was created.
>

First you should use exp73 to perform export. Probably, you need to run catexp7.sql as sys before.
But remember --- Oracle 8 have some options not supported with Oracle 7 (user defined type column for example), so importing a table may not be successful.

Regards,
Piotr
pkol_at_otago.gda.pl Received on Mon May 25 1998 - 12:04:31 CDT