How to fix the Oracle error ORA-36340: (SNSYN130) The format of the PARTITIONCHECK function is: PARTITIONCHECK(aggmap, partition_template)?

In this post, you’ll learn more about the Oracle ErrorORA-36340: (SNSYN130) The format of the PARTITIONCHECK function is: PARTITIONCHECK(aggmap, partition_template) with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-36340: (SNSYN130) The format of the PARTITIONCHECK function is: PARTITIONCHECK(aggmap, partition_template)

Reason for the Error ORA-36340: (SNSYN130) The format of the PARTITIONCHECK function is: PARTITIONCHECK(aggmap, partition_template)

Bad syntax

How to fix the Error ORA-36340: (SNSYN130) The format of the PARTITIONCHECK function is: PARTITIONCHECK(aggmap, partition_template) ?

You can fix this error in Oracle by following the below steps

Correct syntax