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

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

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

A.
Move partitions of a range-partitioned table

B.
Rename partitions of a range partitioned table

C.
Merge partitions of a reference partitioned index

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

E.
Merge partitions of a list partitioned table

F.
Drop partitions of a list partitioned table

Show Hint

Leave a Reply 2

Your email address will not be published. Required fields are marked *

rodge

rodge

No reference given by Patty, so link gives list of what can be performed as multiple partitioning:

https://oracle-base.com/articles/12c/partition-maintenance-operations-on-multiple-partitions-12cr1

ADD PARTITION : RangeComposite Range-*, ListComposite List-*
DROP PARTITION : RangeComposite Range-*, IntervalComposite Interval-*, ListComposite List-*
MERGE PARTITIONS : RangeComposite Range-*, IntervalComposite Interval-*, ListComposite List-*
SPLIT PARTITION : RangeComposite Range-*, IntervalComposite Interval-*, ListComposite List-*
TRUNCATE PARTITION[S] : RangeComposite Range-*, IntervalComposite Interval-*, Hash, ListComposite List-*

You cannot move, rename or coalesce as part of a multipartition operation – the others are all OK to do so.

Reply