| |
- Causa
- obj-type1 obj-name1 CANNOT BE DROPPED BECAUSE IT IS REFERENCED BY obj-type2 obj-name2.
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.
- Ação do sistema
- The statement cannot be processed.
The specified object was not dropped.
- Resposta ao Desenvolvedor
- 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
© Copyright IBM Corp.
|
| |
