| |
- Causa
- A tabela em um tablespace particionado não pode ser explicitamente DROPPED.
The DROP statement failed for the reason indicated by the reason-code as follows:
- 0001
- The DROP TABLE statement attempted to drop a table that resides in a partitioned table space.
- 0002
- The DROP INDEX statement attempted to drop an index required to enforce the primary key, unique key, or referential constraint of the table.
- Ação do sistema
- The statement cannot be processed.
The object is not dropped.
- Resposta ao Desenvolvedor
- If the statement is a DROP TABLE statement, the table of a partitioned table space can only be dropped implicitly when the table space itself is
dropped.
If the statement is a DROP INDEX statement and you do not want to keep the primary key, unique key, or referential constraint, use the DROP
CONSTRAINT clause of the ALTER TABLE statement to remove the constraint, then drop the index.
SQLSTATE: 42917
© Copyright IBM Corp.
|
| |
