Removing a dictionary schema
Removing a dictionary removes the dictionary schema and all data. When you remove a dictionary schema, all synonym lists, coding definitions, assignment rules, and requests entered against the dictionary are lost 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 inactivated the dictionary whose dictionary schema you want to remove.
For more information, see Inactivating a dictionary (Updating a dictionary type and applying the changes to installed dictionaries, Inactivating a dictionary, Reviving a dictionary schema).
- Select the Dictionaries node for the active connection.
- Select a dictionary to remove.
- Select Dictionary > Remove.
A confirmation dialog box appears.
- Click Yes.
- If prompted, enter the user name and password for the dictionary schema administrator, and click OK.
The dictionary remains in the list of Dictionaries. The dictionary status changes to REMOVED.
Note: You must revive this dictionary type before you can use it again to load dictionaries. For more information, see Reviving a dictionary schema.