Cause
For directory based sharding, user needs to specify a valid assignment rule id before using automatic partition assignment feature during insertion.
Action
Specify a valid assignment rule id using PL/SQL setAssignmentRule API.
Oracle 26ai
ORA-05074
Error Message
Assignment rule id is not valid