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.
Note:
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.Parent topic: Maintaining the coding dictionaries