1.2 Application Maintenance

Application maintenance refers to installing, uninstalling, upgrading, or patching an application.

The basic steps for application maintenance are as follows:
  1. Log in to the application root.
  2. Begin the operation with an ALTER PLUGGABLE DATABASE APPLICATION ... BEGIN statement in the application root.
  3. Execute the application maintenance statements.
  4. End the operation with an ALTER PLUGGABLE DATABASE APPLICATION ... END statement.
  • Application Installation
    An application installation is the initial creation of a master application definition. A typical installation creates user accounts, tables, and PL/SQL packages.
  • Application Upgrade
    An application upgrade is a major change to an installed application.

Parent topic: Oracle Multi-Tenant Architecture