-646   TABLE table-name CANNOT BE CREATED IN SPECIFIED TABLE SPACE table-space-name BECAUSE IT ALREADY CONTAINS A TABLE

Explanation

The table space that is specified in a CREATE TABLE statement is one of the following types of table spaces and already contains an existing table:

  • A partitioned table space
  • An implicitly defined table space
  • A LOB table space
  • An XML table space
  • A table space that contains a system-period temporal table or history table

Only one table can exist in these types of table spaces.

System action

The statement cannot be processed. The table was not created.

Programmer response

Verify that the correct table space was specified in the CREATE statement.

SQLSTATE

55017