RE: Oracle 24x7 shops and Patches-Upgrades.

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

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