Oracle Solution for Error ora-34021

Solution for Oracle Error ORA-34021

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

.

What triggered 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.

What should we do to fix it:

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