-770 TABLE table-name CANNOT HAVE A LOB COLUMN UNLESS IT ALSO HAS A ROWID, OR AN XML COLUMN UNLESS IT ALSO HAS A DOCID COLUMN
Explanation
- table-name
- The name of the table.
An attempt was made to create a table, table-name,
with a column that has a dependency on another type of column in the
same table. This error can occur in the following situations:
- The statement attempted to create a table with a LOB column or to add a LOB column to a table, but the table does not have a ROWID column. A table with a LOB column must also have a ROWID column.
- The statement attempted to create a table with an XML column or to add an XML column to a table, but the table does not have a DOCID column. A table with an XML column must also have a DOCID column.
System action
The statement cannot be processed.
Programmer response
If creating a table, define an additional column for the ROWID or DOCID column in the same table.
SQLSTATE
560A6