Merge partition - oracle database script

merge partition - Oracle Database Script.

--  MERGE PARTITION  - FOR COMBINING MULTIPLE PARTITIONS TO A NEW ONE ( 12C ONWARS)  -- SYNTAX : ALTER TABLE <SCHEMA_NAME>.<TABLE_NAME> MERGE PARTITIONS < PARTITION1,PARTITION2,...> < UPDATE GLOBAL INDEXES(optional)>; --- NOTE: UPDATE GLOBAL INDEXES is required if GLOBAL INDEX is present  ALTER TABLE CMADMIN.AODBA MERGE PARTITIONS AODBA_JAN, AODBA_FEB, AODBA_MAR INTO partition AODBA_Q1;