RE: Oracle 24x7 shops and Patches-Upgrades.

  • From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
  • To: <patrick@xxxxxxxxxxxxxx>
  • Date: Thu, 21 Dec 2006 16:44:22 +0100

Patrick

> The main caveat I picked up from Tom Kyte's talk was that tables are
not
> "versionable".  So if one of our upgrades included a change to a table
> then the above approach would not work, and we would have to suffer
> downtime, as currently.  This could be mitigated by encouraging table
> access via views.

Oracle's idea, as mentioned from Tom in his presentation, is to solve
such situation with edition views and cross-edition triggers.


Best regards,
Chris

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


Other related posts: