Hello Every One,
I have the below table and i need to add the few more partitions without dropping the table. Is this possible ?
Below are the partitions needed.
No, you can't add partitions when you use CASE_N.
This should have been RANGE_N from the beginning like this:
RANGE_N (SYR BETWEEN 201501 AND 201504 EACH 1,
201601 AND 201602 EACH 1,
NO RANGE, UNKNOWN)