Re: Urgent: Oracle 8i export files dont work with Oracle 8.0.5

In article <7o6pdp$7vl$1_at_taliesin.netcom.net.uk>,   "Alex Hudghton" <alex_at_alenda.freeserve.co.uk> wrote:
> Aren't you 'migrating' the wrong way ( from 8.1 to 8.0) ?

I have several machines and I need to do data transfers from Oracle on one machine to another. Some have older Oracles and some have newer. In this particular case I need to take a table from Oracle 8i to Oracle 8.0.5

> Is this really supposed to work ?

Why not? All the documentation suggests that it should without a prblem. Also I transfer tables from Oracle 8 to Oracle 7 all the time. I am trying the Oracle 8i for the first time and not having much luck with it. Oracle did a very bad job with Oracle 8i for Linux. It has so many bugs, its not even funny. More than likely I am tripping on yet another bug.

Atif

>
> Alex
>
> Atif wrote in message <7o6nde$cf1$1_at_nnrp1.deja.com>...
> >From an Oracle 8i database under Linux, I exported a
> >simple table using :
> >
> >exp user/password file=monkey.dmp compress=y tables=monkey;
> >
> >and then tried importing it under Oracle 8.0.5 under Linux
> >without any luck using the following:
> >
> >imp user/password file=monkey.dmp buffer=64000 commit=Y fromuser=user
> >touser=user
> >
> >But I get all kinds of garbage errors. It seems that the
> >dumps are not compatible. This is contrary to what Oracle
> >migration docs say.
> >
> >Does anybody have a solution to this problem?
> >
> >Thanks a million in advance.
> >
> >Atif
> >
> >
> >Sent via Deja.com http://www.deja.com/
> >Share what you know. Learn what you don't.
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Aug 03 1999 - 12:12:41 CDT