Which two steps are you recommended to do prior to issuing the dbms_redefinition.start_redef_table procedure call?

Oracle provides a database package called dbms_redefinition to perform an online rebuild of
a table. Which two steps are you recommended to do prior to issuing the
dbms_redefinition.start_redef_table procedure call? (Choose two).

Oracle provides a database package called dbms_redefinition to perform an online rebuild of
a table. Which two steps are you recommended to do prior to issuing the
dbms_redefinition.start_redef_table procedure call? (Choose two).

A.
create any triggers, indexes, or constraints on the interim table

B.
create an empty interim table with all the desired characteristics

C.
invoke thedbms_redefinition.sync_interim_table procedure

D.
invoke thedbms_redefinition.can_redef_table procedure

E.
grant privileges on the interim table

Explanation:



Leave a Reply 0

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