ALTER PLUGGABLE DATABASE APPLICATION ... SYNC statement now accepts multiple application names and names to be excluded. For example, a single statement issued in an application PDB can synchronize
app2, or synchronize all applications except
The expanded syntax enables you to reduce the number of synchronization statements. Also, the database replays the statements in correct order. Assume that you upgrade
ussales from v1 to v2, and then upgrade
eusales from v1 to v2, and then upgrade
ussales from v2 to v3. The statement
ALTER PLUGGABLE DATABASE APPLICATION ussales, eusales SYNC replays the statements in sequence, upgrading
ussales to v2, then
eusales to v2, and then
ussales to v3.
This page provides more detailed information about enhancement of applications synchronization in application PDBs.
This practice shows how to reduce the number of synchronization statements when you have to synchronize multiple applications in application PDBs. In previous Oracle Database versions, you had to execute as many synchronization statements as applications.