© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023
A. Nuijten, P. BarelModern Oracle Database Programminghttps://doi.org/10.1007/978-1-4842-9166-5_19

19. Upgrade Your Application with Zero Downtime

Alex Nuijten1   and Patrick Barel2
(1)
Oosterhout, Noord-Brabant, The Netherlands
(2)
Almere, Flevoland, The Netherlands
 

Upgrading a database application would always require downtime. It was simply not possible to replace PL/SQL objects that were in use. Throughout the years, numerous technologies were developed to reduce Oracle Database downtime, like standby databases, RAC, Streams, online index rebuilds, or online table redefinition. The one thing that could keep users from working uninterrupted is the actual database ...

Get Modern Oracle Database Programming: Level Up Your Skill Set to Oracle's Latest and Most Powerful Features in SQL, PL/SQL, and JSON now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.