Dropping partition 11g/12c - oracle database script

Dropping partition 11g/12c - Oracle Database Script.

-- SYNTAX : ALTER TABLE <SCHEMA_NAME>.<TABLE_NAME> DROP PARTITION < PARTITION_NAME> < UPDATE GLOBAL INDEXES(optional)>; --- NOTE: UPDATE GLOBAL INDEXES is required if GLOBAL INDEX is present  ALTER TABLE CMADMIN.AODBA DROP PARTITION AODBA_JAN UPDATE GLOBAL INDEXES;  --- In oracle 12c, we can drop multiple partitions in one command  ALTER TABLE CMADMIN.AODBA DROP PARTITIONS AODBA_JAN, AODBA_FEB, AODBA_MAR UPDATE GLOBAL INDEXES;