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.