Which three operations can be performed as multipartition operations in Oracle?

Which three operations can be performed as multipartition operations in Oracle?

A.
Merge partitions of a list partitioned table

B.
Drop partitions of a list partitioned table

C.
Coalesce partitions of a hash-partitioned global index.

D.
Move partitions of a range-partitioned table

E.
Rename partitions of a range partitioned table

F.
Merge partitions of a reference partitioned index

Explanation:
Multipartition maintenance enables adding, dropping, truncate, merge, split

operations on multiple partitions.
A: Merge Multiple Partitions:
The new “ALTER TABLE … MERGE PARTITIONS ” help merge multiple partitions or
subpartitions with a single statement. When merging multiple partitions, local and global index
operations and semantics for inheritance of unspecified physical attributes are the same for
merging two partitions.
B: Drop Multiple Partitions:
The new “ALTER TABLE … DROP PARTITIONS ” help drop multiple partitions or subpartitions
with a single statement.
Example:
view plaincopy to clipboardprint?
SQL> ALTER TABLE Tab_tst1 DROP PARTITIONS
Tab_tst1_PART5, Tab_tst1_PART6, Tab_tst1_PART7;
Table altered
SQL>
Restrictions :
– You can’t drop all partitions of the table.
– If the table has a single partition, you will get the error: ORA-14083: cannot drop the only partition
of a partitioned.