Database Error Messages

ORA-14468

invalid INCLUDING ROWS WHERE ... clause

Cause

An invalid INCLUDING ROWS WHERE ... clause was specified. The INCLUDING ROWS WHERE ... clause has the following restrictions:

  • It can only refer to the target table of the DDL.
  • It cannot have subselect queries.
  • It cannot refer to the SYSDATE function.
  • It cannot refer to the ROWNUM pseudo column or the ROWID column.

Action

Rewrite the WHERE clause so that it does not have the restrictions previously listed.