Expanded Syntax for PDB Application Synchronization

The 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 app1 and app2, or synchronize all applications except app3.

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.

Details: Expanded Syntax for PDB Application Synchronization

This page provides more detailed information about enhancement of applications synchronization in application PDBs.

Practice: Synchronizing Multiple Applications 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.

Related Topics