At times, it might be necessary to drop a DB Alias or an Optim™ Directory. Use Drop DB Alias or Optim Tables to guide you in performing one or both tasks.
The following guidelines apply.
Use the Specify Optim Directory dialog (see Specify Optim Directory) to select the name of the Optim Directory that stores the DB Alias you want to drop or to specify the Optim Directory you want to drop. Click Proceed to open the next dialog.
The Optim solution 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.
Use the Create/Select DB Alias dialog (see Create/Select DB Alias) to specify a DB Alias you want to drop. Click Proceed to drop the DB Alias, or click Skip to open the Drop Optim Directory? dialog, which you can use to drop the specified Optim Directory, including all DB Aliases and other objects stored in it.
The Load/Drop Sample Tables dialog prompts you to specify the identifier (such as a Creator ID, Schema Name, Database Name, or Owner ID) for the sample tables to be dropped. For more information, see Load/Drop Sample Tables.
If you have an Optim Data Privacy License, the Load/Drop Data Privacy Tables dialog prompts you to specify the identifier (such as a Creator ID, Schema Name, Database Name, or Owner ID) for the data privacy tables to be dropped. For more information, see Load/Drop Data Privacy Tables.
Before dropping packages, plans, or procedures used to access the database, the Configuration program displays the Create/Drop Packages, Bind/Drop Plans, or Create/Drop Stored Procedures dialog, as appropriate.

To retain the packages, plans, or procedures, click Skip. To browse the DDL used to drop the packages, plans, or procedures, select Display SQL and click Proceed.
After you drop the DB Alias, the Configuration program opens the Drop Another DB Alias? dialog. Select the check box to open the Create/Select DB Alias dialog and restart the process for another DB Alias.
The Configuration program opens the Enable/Disable Optim Server Feature dialog next. You can use this dialog to disable the Server feature.

Click Proceed to disable the Server feature, or click Skip to advance to the next step without disabling the Server feature. If the site is not licensed for the Server, this dialog is not displayed.
The Configuration program opens the Enable/Disable Archive ODBC Feature dialog next. You can use this dialog to disable the Archive ODBC interface feature.

Click Proceed to disable the Archive ODBC feature, or click Skip to advance to the next step without disabling the Archive ODBC feature. If the site is not licensed for Archive, this dialog is not displayed.