This page provides more detailed information about enhancements to applications synchronization in application PDBs.
In Oracle Database 19c, the
ALTER PLUGGABLE DATABASE APPLICATION … SYNC statement accepts only one application name to synchronize with the application root. You have to execute the statement as many times as the number of applications to synchronize with the application root.
In Oracle Database 21c, the
ALTER PLUGGABLE DATABASE APPLICATION … SYNC statement allows you to execute the statement only once for multiple application names. For example, a single statement issued in an application PDB can synchronize
ordsapp, or synchronize all applications except
When applications depend on one another, synchronizing them in a single statement is necessary for functional correctness. Assume that you upgrade
apexapp from 1.0 to 2.0, upgrade
ordsapp from 1.0 to 2.0, and then upgrade
apexapp to 3.0. The
ALTER PLUGGABLE DATABASE APPLICATION apexapp, ordsapp
SYNC statement replays the upgrades in sequence, upgrading
apexapp to 2.0,
ordsapp to 2.0, and then
apexapp to 3.0. Synchronizing
apexapp and then
ordsapp in separate statements does not preserve the upgrade order.