Oracle Error ORA-34021: (MSCGADD04) You must specify a partition when maintaining PARTITION TEMPLATE workspace object.

Oracle Error Message

ORA-34021: (MSCGADD04) You must specify a partition when maintaining PARTITION TEMPLATE workspace object.

Reason for the Error

User attempted to MAINTAINT ADD or DELETE a list value from a LIST partition template, but didn’t specify which partition to add to or delete from.

Solution

Specify the partition: maintain (template) add to partition (partitionname) (values) or maintain (template) delete from partition (partitionname) (values)