Which two statements are true about the migration of BasicFile to the SecureFile format by using the DBMS_REDEFINITION package?

Which two statements are true about the migration of BasicFile to the SecureFile format by using the DBMS_REDEFINITION package? (Choose two.)

Which two statements are true about the migration of BasicFile to the SecureFile format by using the DBMS_REDEFINITION package? (Choose two.)

A.
It can be performed only on tables with a single LOB column.

B.
It automatically creates an interim table during the migration process.

C.
It allows the table that is migrated to be accessed throughout the migration process.

D.
It requires free space that is at least equal to the space used by the table that is migrated.

E.
It requires all constraints defined on the original table to be re-created manually after the migration.

Show Hint

Leave a Reply 3

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

Leo Yu

Leo Yu

(1) verify that the LOB columns of source table is basicFile
(2) create target table with STORE AS SECUREFILE
(3) run DBMS_REDEFINITION.START_REDEF_TABLE to copy over source table to the target table
(4) run DBMS_REDEFINITION.COPY_TABLE_DEPENDENTS to copy over the dependency on source table to the target table
(5) verify the LOB columns of source table is of SecureFile while that of target table is of BasicFile

Reply