QUESTION NO: 45
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.
Answer: A
你需要执行现有销售表的联机
表重定义以将它分割成两个表空间TBS1和TBS2。 带有优先子句的销售表有一个物化视图、 物化日志、 索
引、 参照完整性约束和触发器。 当您执行联机表的重定义时什么样的行动是依赖对象需要的?