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

Explanation

Start of changeFL 508 The table space that is specified in a CREATE TABLE or ALTER TABLESPACE statement is one of the following types of table spaces and already contains an existing table or has a pending definition change to move a table to table-space-name: End of change

  • 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
  • A table space that contains an archive-enabled table or archive table
  • Start of changeFL 508 A table space that is the target table space for a pending ALTER TABLESPACE MOVE TABLE statementEnd of change

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

System action

The statement cannot be processed.Start of change FL 508 The table was not created or moved.End of change

Programmer response

Start of changeVerify that the correct table space was specified in the failing statement.End of change

SQLSTATE

55017