多选题In order to exploit some new storage tiers that have been provisioned by a storage administrator, the partitions of a large heap table must be moved to other tablespaces in your Oracle 12c database? Both local and global partitioned B-tree Indexes are

题目
多选题
In order to exploit some new storage tiers that have been provisioned by a storage administrator, the partitions of a large heap table must be moved to other tablespaces in your Oracle 12c database? Both local and global partitioned B-tree Indexes are defined on the table. A high volume of transactions access the table during the day and a medium volume of transactions access it at night and during weekends. Minimal disrupt ion to availability is required. Which three statements are true about this requirement?()
A

The partitions can be moved online to new tablespaces.

B

Global indexes must be rebuilt manually after moving the partitions.

C

The partitions can be compressed in the same tablespaces.

D

The partitions can be compressed in the new tablespaces.

E

Local indexes must be rebuilt manually after moving the partitions.


相似考题
参考答案和解析
正确答案: C,A
解析: 暂无解析