If you select the option on the Query Method to Apply Maintenance? dialog to apply maintenance for a single DB Alias, the task includes the following steps: create/select the DB alias; connect to the database; drop old packages, plans, or procedures; create/refresh packages, plans, or procedures. After maintenance is applied, the task is complete, or you can choose to apply maintenance for another DB Alias.
When you select Apply Maintenance to a database for a single DB Alias, the Configuration program opens the Create/Select DB Alias dialog allowing you to select the DB Alias for maintenance.

The only available option is to use an existing DB Alias. Specify the name of the DB Alias you want to use. To select from a list, click the down arrow. Click Proceed to open the Connect to Database dialog.
The Configuration program must connect to the database to apply maintenance to the Data Dictionary, Catalog Tables, or System Tables, depending on the DBMS you are using. When the Connect to Database dialog opens, the User ID, Password, Connection String, and DB Name are populated with previously entered values.
The User ID you specify must have DBMS authorization to create or refresh database packages, plans, or procedures. You can modify these values, as needed, and click Proceed to continue.
The Configuration program displays the Drop Old Packages (Plans, or Procedures) dialog. If you select this option and click Proceed, you can drop old packages, plans, or procedures before creating new ones. If you do not select this option, you can create/refresh the appropriate packages, plans, or procedures. The following guidelines apply:
The Configuration program displays the Create/Drop Packages dialog (see Create/Drop Packages), the Bind/Drop Plans dialog, or the Create/Drop Stored Procedures dialog, as appropriate for the DBMS you are using. This dialog allows you to Create/Refresh the
After you apply maintenance for a single DB Alias, the Configuration program opens the Apply Maintenance to Another DB Alias? dialog and prompts you to apply maintenance for another DB Alias: