Truncate partitions - oracle database script

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