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

I'm not sure if this is going to work 100% but you can give it a Try :

1. Set the Compatible parameter in U'r 8i init.ora file = 8.0.5.0 2.Bounce the Database and export using 8i 'exp' binary
2. Run the Oracle 8.0.5 catexp.sql against the 8i Database to create those views used by 8.0.5 4.Import into 8.0.5 Database using the 8.0.5 'imp' binary.

This has worked for me in doing cross version export/imports especially from a Higher version to lower one..

If it doesnt, Oracle Support is the Best Bet...

All the Best,

-Thiru

Atif wrote:

> 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.
Received on Tue Aug 03 1999 - 10:00:57 CDT