---

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.

---

出自：Oracle认证

显示答案