-196 object-type object-name CANNOT BE DROPPED. REASON = reason-code.

Explanation

An attempt was made to drop the specified object, but the object cannot be dropped for the indicated reason.

object-type
The type of the object that the statement attempted to drop. Possible values are:
  • TABLESPACE
  • COLUMN
object-name
The name of the object that the statement attempted to drop.
  • The name of the tablespace if the object type is TABLESPACE.
  • The name of the tablespace followed by the name of the column to be dropped if the object type is COLUMN.
reason-code
1
The tablespace cannot be dropped because it is the last available tablespace.

System action

The statement cannot be processed.

Programmer response

Take the action that corresponds to the reason-code value:
1
If the tablespace must be dropped, create a new one first and alter all tables to associate with the new tablespace. Then run the DROP statement again.

SQLIMSSTATE

42817