What asked for 9.0.2? Are you sure you didn't misread 9.2.0 ? You said you set COMPATIBLE to 9.0.2 and then started getting these errors - ORA-01571: redo version 9.0.2.0.0 incompatible with ORACLE version 8.1.7.0.0
Sounds like maybe you ran a migrate or downgrade script with an invalid COMPATIBLE parameter and that's what hosed it. -----Original Message----- Sent: Thursday, June 05, 2003 10:20 AM To: Multiple recipients of list ORACLE-L Yes. But why is it asking for 9.0.2? I set it to 9.2, 8.1.7, and 9.0.2 just to give it a try. -----Original Message----- Sent: Wednesday, June 04, 2003 7:30 PM To: Multiple recipients of list ORACLE-L I guess this is a silly question, but could it be that Oracle didn't like the COMPATIBLE = 9.0.2 since there is no 9.0.2? I don't know how the comparison is done, but if it's a string comparison I wonder if there will be any bugs with the COMPATIBLE check when version 10 comes out. > -----Original Message----- > From: Koivu, Lisa [mailto:[EMAIL PROTECTED] > > No. I guess by manual I mean I didn't use the gui. I ran the > appropriate upgrade script. > > Gosh I hope it doesn't come to exp/imp... I can't even export > my database. > > -----Original Message----- > > Lisa, when you say you "manually" migrated, did you use > exp/imp after a > fresh CREATE DATABASE in 9i? Also, what platform? 32-bit? > > Rich Jesse System/Database Administrator > [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA > > > > -----Original Message----- > > Lisa > > > > Worry free? I just upgraded another 8.1.7.4 database to > 9.2. When I > > set the COMPATIBLE parm to 9.0.2 (or 9.2, which would make > > sense) I get > > really messy errors: > > > > ORA-00402: database changes by release 9.0.1.3.0 cannot be used by > > release 135294976 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).