DTRHELP.HLB  —  Commands Statements Clauses, DELETE Command
       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
Close Help