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
