Error: SQL0284N The table was not created

DB2 Error: SQL0284N

Description : The table was not created because the table space tablespace-name following the clause clause is a tablespace-type table space.

Explanation:

The CREATE TABLE or DECLARE GLOBAL TEMPORARY TABLE statement specified a table space named tablespace-name following the clause clause that is not a valid type of table space for this clause.

This can occur in the following situations:

• for regular tables, tablespace-name was specified on the IN clause and the table space is not a REGULAR table space.
• for declared temporary tables, tablespace-name was specified on the IN clause and the table space is not a USER TEMPORARY table space.
• tablespace-name was specified on the LONG IN clause and the table space is not a LARGE, managed by database table space.
• tablespace-name was specified on the INDEX IN clause and the table space is not a REGULAR or LARGE, managed by database, table space.

Solution:

Correct the CREATE TABLE statement to specify a table space with the correct type for the clause clause.

Related Posts

1. Error: SQL0290N Table space access is not allowed
2. Error: SQL1749N NOT LOGGED INITIALLY
3. Oracle PL/SQL: Oracle System Tables
4. Error: SQL0161N Insert or Update operation does not conform to the view definition
5. Migrating Oracle Database from HP UNIX to LINUX

Tags: DB2 Error Codes, Table Creation Error, Tablespace Error