Re: Upgrade dependent on database history ?

On Mon, 29 Sep 2003 16:16:37 +0200, "Gerold Krommer" <g.krommer_at_doremove.fns.co.at> wrote:

>
>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.
>
>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
>

IIRC you'll need 8.0.6 mimimum to *migrate* (which involves using the migration assistant). Obviously, this restriction doesn't apply to the *export/import* method.

--
Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address