Re: migrating from oracle 7.3.3 to 8.1.7 question

"michael.cooke" <michael.cooke_at_tinyworld.co.uk> wrote in message news:3ccaf85d_1_at_mk-nntp-1.news.uk.worldonline.com...
> Oracle 7.3.3 on NT4 sp6a to 8.1.7 on NT4 sp6a
> this is a 2fold operation moving 7.3.3 to a new server then in a few weeks
> time migrating to 8.1.7. I am testing the procedure at present and have
both
> oracle versions on the same server in different home directories. The
7.3.3
> dbase is up and running. I have tried a test migration using the gui
> migration tool in 8.1.7 and have a listener problem in tha it can't find
it.
> my question is is there a step by step migration guide covering each item
in
> turn and given that the dbase in question is only 4GB what sort of
timescale
> would be usual for this migration as i believe that in simple terms it is
> the file pointers that are updated along with a number of internal
> datadictionary changes. p.s. I did an export from 7.3 to 8.1.7 which
worked
> problem was it took about 6 hrs (I hope the migration is shorter.).
>
> thanks for any help
>
> Mick
>
>

There is a separate migration manual, please read it.

> would be usual for this migration as i believe that in simple terms it is
> the file pointers that are updated along with a number of internal
> datadictionary changes. p.s. I did an export from 7.3 to 8.1.7 which
worked
> problem was it took about 6 hrs (I hope the migration is shorter.).

You would wish it was a simple as that. As of 8.0 the format of the rowid changed. You need to know whether any of your applications make *explicit* use of the rowid, and *explicitly* expect it to be in the V7 format. Any rowids used by Oracle behind the scenes are dealt with automatically.

As a result during migration the old rowids remain unchanged. Individuals rows will be converted as soon as your app uses them.

That is why, and also for purposes of database reorganisation, you are advised to use exp/imp. As imp is basically a series of inserts, the rowid is converted to the new format everywhere, and your database is reorganized at the same time.

Also, migrating (which means in situ migration, you don't have 2 databases, so if the migration bombs out, you need to restore) might not be possible at all from 7.3.3 to 8.1.7, as the version difference is too big.

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address