Database Error Messages

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

ORA-42044

cannot redefine table with non-null VPD policy predicate against the table owner or redefinition invoker

Cause

Virtual Private Database (VPD) policies with non-null predicate against the table owner or redefinition invoker existed on the original table.


Action

Drop the VPD policies with non-null predicate against the table owner or redefinition invoker. Restart online redefinition.