Re: 10g upgrade survey

On Mon, 05 Mar 2007 14:23:33 -0800, "Jeremiah Wilton" <jeremiah_at_ora-600.net> said:

Good response from Jeremial Wilton. That reminds me of another aspect ; The Export/Import method "RESET"s the reation date/time of the objects ; This is surely not acceptable to me; On many instances during the lifecycle of the database / implementation(s) the Creation date + Last DDL Time + Timestamp have come in handy.

> - Moving to LMT: What is wrong with migrating to LMTs? It can be done
> bit by bit in shorter outage windows an with much lower stakes.

Well said. No need to club with migration/upgrade. If any problem arises you would know where to look at.

> - The data dictionary could not be upgraded due to corruption: This is
> the only good reason I could find in all the responses. Still, support
> should have been able to help you make your DD upgradeable. What if the
> DB had been 10T?

Again another correct statement. We did upload the system tablespace datafiles to Oracle but the response was use the exp/imp since we told them that the db size (in this case) is just 70GB!!!!!.

HTH
GovindanK

--
http://www.freelists.org/webpage/oracle-l