How to change the default initial and next for new partitions in oracle
Actually the &quot;FOR PARTITION&quot; part of my query was the issue.
This worked :
ALTER TABLE MY_EVENTS MODIFY DEFAULT ATTRIBUTES 
STORAGE (INITIAL 65536 NEXT 65536);