Re: Upgrade dependent on database history ?

"Gerold Krommer" <g.krommer_at_doremove.fns.co.at> wrote in message news:<bl9esa$igb$1_at_at-vie-newsmaster01.nextra.at>...
> Hi all,
>
> as I mentioned in another Oracle newsgroup, I'm embarking on a weekend that
> (amongst others) includes an Oracle 8.0.4 to 8.1.7.4 upgrade (on HPUX).
>
> The database is part of a DMS system containing 70 million documents. The
> DMS vendor has only certified an upgrade procedure that goes from 8.0.6 to
> 8.1.7.4 thus requiring us to do an 8.0.4 to 8.0.6 upgrade beforehand,
> something that I feel is an unneccessary waste of time.

I have a vague recollection of some sort of bug that would get this error. But it's been too long... Anyways, see metalink Note: 133920.1 , and bug 1362374 is interesting just to show you never can tell when CBO will bite you :-)

And I've gotten ORA-904 at odd times just from imp.

>
> The vendors support group has told us that they have seen (sometimes)
> problems going from 8.0.4 to 8.1.7.4 with databases that were migrated from
> V7 databases. Something along the lines of 'missing columns or tables'.
> Those problems were not seen if they went V7-8.0.4-8.0.6-8.1.7 as opposed to
> V7-8.04-8.1.7.
>
> Does anyone know about such troubles ? Could it be that different
> *supported* upgrade paths yield logically different databases ?
> I do not believe I will run into this since the database was exported from a
> V7 system and imported to the 8.0.4 but still I would like to
> be 'armed' with know-how.
>
> Thanks for sharing,
>
> /Gerold

jg

--
@home.com is bogus.
Buccaneer!