ORA-05074
Assignment rule id is not valid
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.