alter drop multiple partitions (> 255) never complete
Last updated on OCTOBER 23, 2017
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 and later
Information in this document applies to any platform.
1. Table having 800 + partitions
2. If try to drop partitions (more than 256) at a time using alter drop
statement then the alter statement never completes.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms