Format DELETE COLLECTION [ qualifier ] ... collection-name ,... .
1 – Parameters
1.1 – collection-name
Specifies the collection you are deleting.
2 – Qualifiers
2.1 /DESCENDANTS
Format options: /DESCENDANTS /NODESCENDANTS (default) Specifies whether CDO deletes members. When you specify the /DESCENDANTS qualifier, CDO deletes all members that are not also members of additional elements outside the area defined by your top collection.
2.2 /LOG
Format options: /LOG /NOLOG (default) Specifies whether CDO displays text confirming that the collection is deleted.
3 – Description
The DELETE COLLECTION command deletes a collection and, optionally, all members of the collection. Because a collection is a controlled element, CDO freezes previous versions and allows you to delete only the highest visible version. If a collection is a member, you must delete its owners before you delete the collection. If the collection's immediate owner is a member of another element, you must trace the relationships back until you reach the element that has no owners and delete elements one by one, in sequence of ownership. If you attempt to delete a collection that owns a version in a different branch, the version must be the latest version in that branch. Otherwise, an error will occur. See the Oracle CDD/Repository Architecture Manual for complete information on branch lines of descent.
4 – Examples
1.CDO> DELETE COLLECTION A_COLLECTION. In this example, the DELETE COLLECTION command deletes a collection that is not a member. 2.CDO> DELETE COLLECTION REGIONAL_SALES. CDO> DELETE COLLECTION DISTRICT_SALES. CDO> DELETE COLLECTION LOCAL_AREA_SALES. In this example, the DELETE COLLECTION command deletes a collection, a subcollection, and a further subcollection in sequence of ownership. 3.CDO> DELETE COLLECTION COMPILER_C(3). CDO> DELETE COLLECTION COMPILER_C(2:UPDATE_BRANCH:2). CDO> DELETE COLLECTION COMPILER(2:UPDATE_BRANCH:1). CDO> DELETE COLLECTION COMPILER_C(2). CDO> DELETE COLLECTION COMPILER(1). In this example, successive DELETE COLLECTION commands delete the main line and branch line versions of a collection in sequence of ownership. The branch line originates from version 2 and merges back in version 3.