Database Error Messages

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

ORA-14852

SET [SUB]PARTITIONING AUTOMATIC is not legal on this table.

Cause

SET [SUB]PARTITIONING AUTOMATIC clause was specified. ALTER TABLE SET [SUB]PARTITIONING AUTOMATIC is only legal on a list partitioned table. Additionally, this table cannot have a DEFAULT partition.


Action

Use SET [SUB]PARTITIONING AUTOMATIC only on a valid table.