-763 INVALID TABLE SPACE NAME space-name
Explanation
The named table space is invalid.
- space-name
- The name of the table space.
Possible reasons for this error include:
- It is a LOB table space and therefore cannot reside in a work file database.
- It is a LOB table space and therefore cannot contain a non-auxiliary table.
- It is not a LOB table space and therefore cannot contain an auxiliary table.
- It is a LOB table space and LOGGED was specified, but the associated base table space is defined as NOT LOGGED.
- It is a hash table and therefore can exist only in a range-partitioned universal table space or a partition-by-growth table space. Hash tables cannot be created XML table spaces or in any other type of table space, and tables cannot be altered to use hash access unless they are of one of those types.
System action
The statement cannot be processed.
Programmer response
Take the appropriate action:
- Create the LOB table space in a non-workfile database.
- Create the table in a non-LOB table space.
- Create the auxiliary table in a LOB table space.
- Create a LOB table space and do not specify LOGGED.
- For a hash-organized table, create a universal table space that is not an XML or LOB table space.
SQLSTATE
560A1
