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