Deleting a dictionary

Deleted dictionaries cannot be revived or reactivated. When you delete a dictionary, all synonym lists, coding definitions, assignment rules, and requests entered against the dictionary become invalid and cannot be retrieved.

Caution: Oracle recommends that you do not remove the dictionary schema or delete a dictionary that has been used for coding. Delete only dictionaries that you have set up but have not coded against.

Select Start > Apps > Dictionary Loader.
The Dictionary Loader dialog box appears.
Select a connection and connect to the database.
For more information, see Connecting to the database.
Make sure that you have removed the schema for the dictionary that you want to delete.
For more information, see Removing a dictionary schema.
Select the Dictionaries node for the active connection.
Select a dictionary.
Select Dictionary > Delete.
A confirmation dialog box appears.
Click Yes.
If prompted, enter the user name and password for the dictionary database administrator, and click OK.