Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Update schema while new data is coming in

Re: Update schema while new data is coming in

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Tue, 13 Nov 2007 10:42:23 +0000
Message-ID: <7765c8970711130242l7a84182dm158fdfd8e2cafb37@mail.gmail.com>


I'd require of management and the customer that they only sent data to the old application that was entirely compatible with the new application. Or to put it another way it depends on the complexity of the application and the upgrade. If the new schema and application logic is 100% compatible with the old schema (i.e you are just adding things on and not 'fixing' anything) then you'll likely get away with it - for a reasonable upgrade of a moderately complex application you are extremely likely to find data issues after the upgrade.

On Nov 12, 2007 9:47 AM, < Antje.Stejskal_at_ppimedia.de> wrote:

> Hi,
>
> we are having a web application that ist o be online availyble 7x24. We
> plan
> for the scenario that the application needs a software update (new tables
> ,
> modified tables et. al.) Management and customer requires that the
> application is still running while the upgrade goes on. How would you
> solve
> this, that you have one server with the old schema where new data is
> coming
> in, meanwhile another server is brought up to latest release. And data of
> the old server (or delta of data) will be send to new server. We will
> propably have 2 servers anyway because of the traffic.
> Please help me with your ideas.
>
> Regards
> Antje Stejskal
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Nov 13 2007 - 04:42:23 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US