Drop the Optim Directory?

If you do not drop another DB Alias, the Configuration program opens the Drop the Optim Directory dialog. Select the check box to drop the Optim™ Directory.

Connect to Database

Optim must connect to the database to drop the Optim Directory tables and packages, plans, or procedures. Use the Connect to Database dialog (see Connect to Database) to specify the connection information.

Drop Optim Directory Tables

Before you drop an Optim Directory (and Directory tables), the Configuration program displays the table identifier and prompts you to review the generated DDL on the Drop Optim Directory Tables dialog.

Example of the Drop DB Alias/Optim Tables - Drop the Optim Directory? dialog.

To retain the Optim Directory tables and objects in it, click Skip.

Create/Drop Packages

When you drop an Optim Directory, all objects that are stored in that Directory are deleted. For this reason, the packages, plans, or procedures that are used to access the Optim Directory are no longer useful and can be dropped. The Create/Drop Packages, Bind/Drop Plans, or Create/Drop Stored Procedures dialog prompts you to do this step.

Drop Another Optim Directory?

After you drop the Optim Directory, the Configuration program opens the Drop Another Optim Directory? dialog. Select the check box to restart the process for another Optim Directory.



Feedback