Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Urgent: Oracle 8i export files dont work with Oracle 8.0.5
I have not read the migration doc for 8i, however , going on past
experience, I would imagine that the compatibility is one way. That is
8i (8.1) can read 8.0 dumps but not vica versa. Usually the export
views change between releases.
Clive.
On Tue, 03 Aug 1999 16:16:09 GMT, andreyNSPAM_at_bookexchange.net (NetComrade) wrote:
>simply not allowed. I don't know if there is a way around this. Maybe
>only using SQL*LOADER/flatfiles
>
>On Tue, 03 Aug 1999 12:30:38 GMT, Atif <atif55_at_my-deja.com> 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.
>
>---------------
>Andrey Dmitriev eFax: (978) 383-5892 Daytime: (917) 373-5417
>AOL: NetComrade ICQ: 11340726 remove NSPAM to email
>
Received on Sun Aug 08 1999 - 03:40:53 CDT