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.