Deletes one or more dictionary objects and their access control
lists from the Oracle CDD/Repository data dictionary system.
Format
DELETE path-name-1 [,...] ;
1 – Arguments
path-name
Is the given name, full dictionary path name, or relative path
name of the dictionary object you want to remove from the
data dictionary system. DELETE accepts both DMU and CDO style
path names. If you specify more than one dictionary path name,
separate each path name from the next with a comma.
; (semicolon)
Ends the DELETE command.
2 – Examples
The following example shows how to delete two domain versions
from your default dictionary:
DTR> SHOW DOMAINS
Domains:
* YACHTS;4 * YACHTS;3 * YACHTS;2 * YACHTS;1
The following example does not specify a version number, so DEC
DATATRIEVE deletes the highest version, YACHTS;4.
DTR> DELETE YACHTS;
DTR> SHOW DOMAINS
Domains:
* YACHTS;3 * YACHTS;2 * YACHTS;1
DTR> DELETE YACHTS;2;
DTR> SHOW DOMAINS
Domains:
* YACHTS;3 * YACHTS;1