Xref: alice comp.databases.oracle.server:60816 Path: alice!news-feed.fnsi.net!newsfeed.icl.net!newsfeed1.news.nl.uu.net!sun4nl!bullseye.news.demon.net!demon!news.demon.co.uk!demon!shimmer.demon.co.uk!not-for-mail From: clive@shimmer.demon.co.uk (Clive) Newsgroups: comp.databases.oracle.server Subject: Re: Urgent: Oracle 8i export files dont work with Oracle 8.0.5 Date: Sun, 08 Aug 1999 08:40:53 GMT Message-ID: <37ac08c6.146067631@news.demon.co.uk> References: <7o6nde$cf1$1@nnrp1.deja.com> <37a715a5.9241648@news.earthlink.net> X-Trace: news.demon.co.uk 934101653 nnrp-13:23720 NO-IDENT shimmer.demon.co.uk:158.152.252.208 X-Complaints-To: abuse@demon.net X-Newsreader: Forte Free Agent 1.1/32.230 Lines: 45 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@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 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 >