Re: Index ROWID updates when migrating to Oracle8

Hi Matt,

In the Oracle 8 New Features for Administrators course I learned, that using migration assistant all rowids are converted as soon as the row is 'touched' ie 'read'.
Using exp/imp all rowids are converted during imp.

Hth,

Sybrand Bakker, Oracle DBA

Matt Adams wrote in message <01be9bc7$6b124830$053a1faa_at_23bnhvb>...
>The Oracle Migration instructions when going from Oracle 7.3 to
>Oracle8 suggest taking offline all tablespaces other than SYSTEM and
>whatever
>tablespaces hold rollback segments. If this is done, then obviously the
>indexes in these offline tablespace cannot be altered during the migration
>process.
>
>Indexes store ROWIDs associated with each entry. This rowid format
>changes dramatically in oracle8 (going from 7 bytes to 10).
>
>Questions for the group: How and when do the indexes get updated with the
>new
>ROWIDs after the migration is complete and the tablespaces are brought back
>online?
> Whenever an index block is read to satisfy a query? Whenever any index
>entry is altered
>and the index block has to be re-written? What is the impact on
>performance of doing
>these updates to the indexes? Can we force an update of the ROWIDs in the
>indexes
>without doing an ALTER INDEX ... REBUILD?
>
>anybody have any opinions (or better yet, facts from Oracle)?
>
>
>--
>Opinions expressed are not necessarily shared by my emplorer.
Received on Tue May 11 1999 - 11:35:27 CDT