Re: Oracle8 Exp/Imp question

In article <6kc8b4$mul$1_at_sunrise.pg.gda.pl>,   "Piotr Kolodziej" <pkol_at_otago.gda.pl> wrote:
>
>
> 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=20
> a table may not be successful.
>
> Regards,
> Piotr
> pkol_at_otago.gda.pl
>
>

is the imp/exp backward compatable. has anyone seen this problem (listed above) with exp 7.1.x and imp 7.3? i looked..but couldnt see any reference to these errors on previous version when going backward...

Johnnie

jeshou_at_worldnet.att.net
jsuggs_at_lgc.com

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Mon Jun 01 1998 - 15:52:28 CDT