Database Error Messages

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

ORA-31111

table string cannot be hierarchically enabled

Cause

Trigger tabname_xdb_pitrigger already exists


Action

Either the table is already hierarchically enabled or the user trigger tabname_xdb_pitrigger needs to be dropped.

Delete all rows in the hierarchical index and then rebuild it.