-771 INVALID SPECIFICATION OF A ROWID COLUMN

Explanation

For an ALTER TABLE or CREATE TABLE statement, the specification of a ROWID column might be invalid for one of the following reasons:

• A ROWID column cannot be added to a temporary table.
• A ROWID column cannot be specified in a referential-constraint clause as a column of a foreign key.
• A ROWID column cannot be a column of a primary key or unique key.
• A ROWID column cannot be a column in a table with an edit procedure that is defined with row attribute sensitivity.
• A ROWID column cannot be part of the implicit or explicit column list for fullselect in the as-result-table clause of a CREATE TABLE or DECLARE GLOBAL TEMPORARY TABLE statement.
• A ROWID column that is implicitly generated cannot be dropped.
• A ROWID column that is defined as GENERATED BY DEFAULT cannot be dropped if the table contains an implicitly generated ROWID column.
• A ROWID column cannot be dropped if the table contains LOB columns that are dependent on the ROWID column.