-646 TABLE table-name CANNOT BE CREATED IN OR MOVED TO SPECIFIED TABLE SPACE table-space-name BECAUSE IT ALREADY CONTAINS A TABLE
Explanation
FL 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:
- 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
- FL 508 A table space that is the target table space for a pending ALTER TABLESPACE MOVE TABLE statement
Only one table can exist in these types of table spaces.
System action
The statement cannot be processed. FL 508 The table was not created or moved.
Programmer response
Verify that the correct table space was specified in the failing statement.
SQLSTATE
55017