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

The ADMIN_EMP table has columns EMPNO, ENAME, DEPTNO, and SAL. It has a
materialized view EMP_MV with a materialized log and an ENAME_IDX index on the
ENAME column. You need to perform an online table redefinition on the ADMIN_EMP table
to move it from the TBS1 tablespace to the TBS2 tablespace in the same schema. What
action is required for the dependent objects when you perform online redefinition on the
table?

The ADMIN_EMP table has columns EMPNO, ENAME, DEPTNO, and SAL. It has a
materialized view EMP_MV with a materialized log and an ENAME_IDX index on the
ENAME column. You need to perform an online table redefinition on the ADMIN_EMP table
to move it from the TBS1 tablespace to the TBS2 tablespace in the same schema. What
action is required for the dependent objects when you perform online redefinition on the
table?

A.
The materialized view should have a fast refresh performed after the online table
redefinition is completed.

B.
The materialized view should have a complete refresh performed after the online table
redefinition is completed.

C.
The materialized view, materialized log, and the index should be dropped and re-created
after the online table redefinition is complete.

D.
The materialized view and materialized log should be dropped and all constraints
disabled and re-created after the online table redefinition is complete.



Leave a Reply 0

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