Apply Maintenance for Specific DBMS

If you select the option on the Query Method to Apply Maintenance dialog to apply maintenance for a specific DBMS, the task includes the following steps.

  1. Specify the DB Alias DBMS (Type and Version).
  2. Choose to apply maintenance for the first or another DB Alias.
  3. Connect to the Database.
  4. Drop old Packages, Plans, or Procedures.
  5. Create/Refresh Packages, Plans, or Procedures.

After maintenance is applied, you can choose to apply maintenance to databases in a different DBMS, or the maintenance task is complete.

Specify DB Alias DBMS

When you select Apply Maintenance to databases with a specified DBMS Type and Version, the Configuration program opens the Specify DB Alias DBMS dialog.

Apply Maintenance for DB Alias Access - Specify DB Alias DBMS dialog

Specify the DBMS Type and Version, and click Proceed to open the Apply Maintenance to DB Alias? dialog. To continue, select the DB Alias, connect to the database, and create/drop packages, plans, or procedures.

Note: The steps are the same as those previously described to apply maintenance for all DB Aliases.

Apply Maintenance to Another DBMS Type?

After you apply maintenance to the database in the selected DBMS, the Configuration program opens the Apply Maintenance to Another DBMS Type? dialog and prompts you to confirm maintenance for a different database DBMS.

Apply Maintenance for DB Alias Access - Apply Maintenance to Another DBMS Type dialog

On this dialog, you can do the following:



Feedback