You have an Oracle Database 11g on-premises database with encrypted tablespaces. You want to migrate this database to the pre-created database of the Database as a Service (DBaaS) instance on Oracle…

Question

Options

• AThe on-premises database platform must be of the same endianness as the DBaaS platform.
• BYou can use Full Transportable (TDB).
• CYou can use Data Pump TTS with the ENCRYPTION_PASSWORD parameter.
• DYou can use Data Pump TTS with the ENCRYPTED_PASSWORD parameter.
• EData is sent in clear when the NETWORK_LINK option is used.

• A
  81% (29)
• B
  6% (2)
• D
  3% (1)
• E
  11% (4)

Explanation

The Data Pump Transportable Tablespace method can be used only if the on-premises platform is little endian, and the database character sets of your on-premises database and Oracle Database Cloud Service database are compatible. Note: If the job you are attaching to was initially started using an encryption password, then when you attach to the job you must again enter the ENCRYPTION_PASSWORD parameter on the command line to re-specify that password. The only exception to this is if the job was initially started with the ENCRYPTION=ENCRYPTED_COLUMNS_ONLY parameter. In that case, the encryption password is not needed when attaching to the job. https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/mig-11g-11g.html

No community discussion yet for this question.