Details: Expanded Syntax for PDB Application Synchronization

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 apexapp and ordsapp, or synchronize all applications except ordsapp.

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.