So, to summarize: 9.2.0.x = Oracle 9i Release 2 9.0.1.x = Oracle 9i Release 1 9.1.0.x was never released. Mark J. Bobak Oracle DBA ProQuest Company Ann Arbor, MI "Post Hoc Ergo Propter Hoc" -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Pete Sharman Sent: Thursday, June 17, 2004 4:37 PM To: oracle-l@xxxxxxxxxxxxx Cc: Peter Ross Sharman Subject: RE: 9.2.0.5 TO 9.1.0.1 Well, I think there are two versions we could be looking at here. 9.2.0.1 was the first Production release of 9.2 IIRC, or they could mean 9i Release 1 in which case it's 9.0.1.x. I don't think there are any problems with exporting from 9.2 and importing to 9.0, but maybe others can comment more knowledgeably than I (not difficult at the best of times, I know. :-)) Pete "Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handbook "Oh no, it's not. It's much harder than that!" Bruce Pihlamae, long-term Oracle DBA -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jared.Still@xxxxxxxxxxx Sent: Friday, 18 June 2004 6:18 AM To: oracle-l@xxxxxxxxxxxxx Subject: RE: 9.2.0.5 TO 9.1.0.1 Please reread Pete's reply. There is no 9.1 version. There is however a 9.2.0.1, which I believe was R1. If there are sufficient differences between R1 and R2 such that an export from r2 generates errors while importing into r1, it is very likely you can't do that. You will need to bulid a 9.2.0.5 database, load the export file, then use the 9.2.0.1 exp utility to export into a compatible format. Jared Hamid Alavi <hamid.alavi@xxxxxxxxxxx> Sent by: oracle-l-bounce@xxxxxxxxxxxxx 06/17/2004 01:18 PM Please respond to oracle-l@xxxxxxxxxxxxx To "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx> cc Subject RE: 9.2.0.5 TO 9.1.0.1 I have a dump file from oracle 9.2.0.5 and want to import into 9.1.0.1 or 9 release 1 -----Original Message----- From: Pete Sharman [mailto:peter.sharman@xxxxxxxxxx] Sent: Thursday, June 17, 2004 1:02 PM To: oracle-l@xxxxxxxxxxxxx Cc: Peter Ross Sharman Subject: RE: 9.2.0.5 TO 9.1.0.1 9.1 anything never existed as a version. It went from 9.0.1.something to 9.2.0.something. Where did you manage to get the 9.1 code? ;) Pete ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------