You need to perform an online table redefinition of an existing SALES table to partition it into two tablespaces TBS1 and TBS2. The SALES table has a materialized view, materialized log, indexes, referential integrity constraint, and triggers with the PRECEDES clause existing on it. What action is required for dependent objects when you perform online table redefinition?()
- A、 The dependent materialized view should have a complete refresh performed after the online table redefinition process.
- B、 Triggers with the PRECEDES clause should be disabled before the online table redefinition process.
- C、 Referential integrity constraints must be manually enabled after the online table redefinition process.
- D、 The materialized log should be dropped before the online table redefinition process.
正确答案:A
答案解析:有
微信扫一扫手机做题