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.