Skip to Main Content
Evolve your applications online with Edition-Based Redefinition, Online Redefinition

About This Workshop

Youtube Video

About This Workshop
This hands-on lab will cover how to evolve your applications built on top of the Oracle database entirely online using features like Edition-Based Redefinition (EBR) Online Redefinition. Oracle Edition-based Redefinition (EBR) provides the ability to do online application upgrades without the need for any downtime. In this lab, we will explore the building blocks of EBR and build out a sample schema using the popular schema versioning tool Liquibase, Oracle SQL Developer Command Line (SQLcl), and walk through how EBR, DBMS_REDEFINITION package can be used to enable CI/CD processes to ensure maximum flexibility and availability.

Workshop Info

2 hours
  • Create the Autonomous Database
  • Create and populate the HR schema 
  • Use EBR with SQLcl and Liquibase to create a new version of the Employees table
  • Redefine the physical structure of the table with DBMS_REDEFINITION
  • Decommission the old edition
  • Familiarity with PL/SQL is desirable, but not required
  • Some understanding of cloud and CI/CD concepts is helpful
  • Familiarity with Oracle Cloud Infrastructure (OCI) is helpful

Other Workshops you might like