Database Error Messages

ORA-62612

operation disallowed; column with ROWID type cannot be created in Oracle Autonomous Database Cloud

Cause

An attempt was made to create a table with ROWID column type. By default, Oracle Autonomous Database Cloud runs with ROW MOVEMENT enabled. Hence, ROWIDs stored in ROWID column may not be valid if rows are moved by automated maintenance operations, such as table shrink.


Action

Set ATP_ALLOW_ROWID_COLUMN_TYPE=TRUE and disable row movement of the tables that are referenced by the ROWID column.