-616 obj-type1 obj-name1 CANNOT BE DROPPED BECAUSE IT IS REFERENCED BY obj-type2 obj-name2
Explanation
Some types of objects cannot be dropped if there are other objects which are dependent upon them. For example, a storage group cannot be dropped if there are one or more existing table spaces that use that storage group.
Execution of the specified DROP statement would drop object obj-name1 of type obj-type1 on which object obj-name2 of type obj-type2 is dependent.
System action
The statement cannot be processed. The specified object was not dropped.
Programmer response
Verify that the object specified in the DROP statement was, indeed, the object to be dropped. If so, all the existing objects that have a dependency on that object must first be dropped.
A LOB table space cannot be dropped when an association exists between it and another table space. The associated base table must be dropped first.
A populated auxiliary table and its index can only be dropped by dropping the associated base table.
A trigger package cannot be explicitly dropped. It can only be dropped by dropping the associated trigger with a DROP TRIGGER statement or by dropping the triggering table.
SQLSTATE
42893