Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

ORA-32462

cannot use an object modified in current transaction

Cause

An object modified in the current transaction was found during the creation of in-memory private temporary table using CREATE TABLE AS SELECT (CTAS).


Action

Split the CTAS statement into CREATE TABLE followed by INSERT SELECT.