-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