DB2 Error Code – -669 a table in a partitioned tablespace cannot be explicitly dropped

In this post, you’ll learn about the error message -669 a table in a partitioned tablespace cannot be explicitly dropped in the IBM DB2 database , the reason why it occurs along with the solution to fix it

IBM DB2 Error Message

-669 a table in a partitioned tablespace cannot be explicitly dropped

Reason for the Error

The DROP TABLE statement attempted to drop a table that resides in a partitioned table space.

Solution

The table of a partitioned table space can only be dropped implicitly when the table space itself is dropped.