A collection of tutorials, code and tools to help you get better using Oracle
26 May 2011
Oracle 11gR2 introduced the ability to make changes to tables and running PLSQL without impacting the live application in any way. This series of articles walks through using these new features.
Fixing a bug in a live PLSQL application without an outage has always been a tricky problem in Oracle, until 11gR2 when a new feature changed things completely ...
Not all application changes are as simple as just a code change - sometimes the underlying database schema needs changed too. So what are the options there?
When you need to change the definition of an existing database column, or fundamentally change the structure of a live table it can usually be done online with careful design and cross edition triggers.
A summary of the key points and commands necessary for online upgrades