The DELETE GENERIC command deletes a generic element. This
    element can be based on a type supplied by Oracle CDD/Repository
    or a user-supplied type.

    If a generic element is a controlled versioned element, CDO
    freezes previous versions and allows you to modify only the
    highest visible version. If a generic element is an uncontrolled
    versioned element, CDO deletes the highest version unless you
    specify another version number.

    If you use SQL (structured query language) to delete an Oracle
    Rdb database file, the corresponding CDD$DATABASE element may
    remain in Oracle CDD/Repository. You can use the DELETE GENERIC
    command to delete this element.