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.
正确答案:A,B,D
答案解析:有
微信扫一扫手机做题