-747 TABLE table-name IS NOT AVAILABLE UNTIL THE AUXILIARY TABLES AND INDEXES FOR ITS EXTERNALLY STORED COLUMNS HAVE BEEN CREATED
Explanation
An attempt was made to access or reference a table
with one or more LOB columns, however either
- an auxiliary table for storing one of the LOB columns has not been created, or
- an index has not been created for an auxiliary table, or
- there is not an auxiliary table for each partition of the table space.
System action
The statement cannot be processed.
Programmer response
- Use CREATE TABLESPACE to create a LOB table space.
- Use CREATE TABLE to create the auxiliary table for storing the column.
- Use CREATE INDEX to create an index on the auxiliary table.
- Resubmit the statement that failed.
SQLSTATE
57054