In this post, you’ll learn more about the Oracle ErrorORA-03204: the segment type specification should indicate partitioning with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
ORA-03204: the segment type specification should indicate partitioning
Reason for the Error ORA-03204: the segment type specification should indicate partitioning
partition name is specified for the space analysis, but the object type does not indicate parttitioning
How to fix the Error ORA-03204: the segment type specification should indicate partitioning ?
You can fix this error in Oracle by following the below steps
specify PARTITION in the segment type, if the object is partitioned, otherwise, omit the partition name