Oracle Database: Program with PL/SQL — Question 39

Which two are correct when migrating BasicFile LOBs to SecureFile LOBs by DBMS_REDEFINITION?

Answer options

• A. Online redefinition can be done only at the table level.
• B. Specify only BasicFiles LOB and SecureFiles LOB column names in parameter col_mapping of DBMS_REDEFINITION.START_REDEF_TABLE.
• C. Set the database initialization parameter db_securefile to NEVER.
• D. During migration, specify the NOLOGGING storage parameter for any new SecureFiles LOB columns.
• E. Online redefinition is the recommended method for migration of BasicFile LOBs to Secure LOBs.

Correct answer: B, E

Explanation

Option B is correct because it specifies the appropriate column names required for the migration process. Option E is also correct as online redefinition is indeed the recommended method for this type of migration. The other options are incorrect because A restricts the scope of online redefinition, C sets the db_securefile parameter improperly, and D suggests an incorrect storage parameter usage during migration.