upgrade to 11g, it handles it. :)
It handles this application schema upgrade online for you with a no-downtime switchover on a per user basis.
<quote>
•Oracle Database 11g introduces revolutionary new capabilities that allow online application upgrade with continuous availability of the application
•The pre-upgrade application and the post-upgrade application can be used at the same time
•
Each end-user session is rolled over on its own schedule
•Oracle Database 11g brings the Edition, the Editioning View, and the CrossEdition Trigger
•Code changes are installed in the privacy of a new edition.
•
Data changes are made safely by writing only to new columns or new tables not seen by the old Edition
•An Editioning View exposes a different projection of a table into each edition to allow each to see just its own columns
•
A CrossEdition trigger propagates data changes made by the old edition into the new edition’s columns, or (in hot-rollover) vice-versa
----- Original Message ----
From: John Dunn <jdunn@sefas.com>
To: oracle-l digest users <oracle-l@freelists.org>
Sent: Monday, December 4, 2006 5:17:21 AM
Subject: Advise needed on moving data with table changes
We have a new version of an application which involves lots of changes to
tables
e.g. columns added, columns deleted, columns renamed, columns moved to new
tables
We needed to upgrade the live system and move the data to the new table
formats.
What is the best approach here? What oracle utilities will handle this best?
John Dunn
--
http://www.freelists.org/webpage/oracle-l
____________________________________________________________________________________
Yahoo! Music Unlimited
Access over 1 million songs.
http://music.yahoo.com/unlimited
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Dec 04 2006 - 22:22:35 CST
