What action is required for dependent objects when you perform online table redefinition?

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?

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.
Triggers with the PRECEDES clause should be disabled before the online table
redefinition process.

B.
Referential integrity constraints must be manually enabled after the online table
redefinition process.

C.
The dependent materialized view should have a complete refresh performed after the
online table redefinition process.

D.
The materialized log should be dropped before the online table redefinition process.



Leave a Reply 0

Your email address will not be published. Required fields are marked *