1Z0-160 · Question #14
You want to migrate an Oracle Database 11.2.0.2 on-premises database to the Oracle Database 11g database of the Database as a Service (DBaaS) instance on Oracle Cloud. A subset of the data that you…
The correct answer is B. Data Pump TTS. The Data Pump Transportable Tablespace 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. The Transportable Tablespace method is generally much…
Question
You want to migrate an Oracle Database 11.2.0.2 on-premises database to the Oracle Database 11g database of the Database as a Service (DBaaS) instance on Oracle Cloud. A subset of the data that you want to transfer includes data stored in LONG data type columns. All required data is contained in a dedicated tablespace. The tablespace is 100 GB in size and has 20% free space. The client wants the data migrated in the shortest possible time to minimize impact on end users. Select the most appropriate migration method to meet this requirement.
Options
- AData Pump TDB
- BData Pump TTS
- CSQL*Loader Direct Path
- Dconventional export/import
- ERemote Cloning
How the community answered
(31 responses)- A10% (3)
- B84% (26)
- C3% (1)
- D3% (1)
Explanation
The Data Pump Transportable Tablespace 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. The Transportable Tablespace method is generally much faster than a conventional export/import of the same data because the data files containing all of the actual data are simply copied to the destination location. Incorrect Answers: C: Data Pump TDB is not supported in this scenario. D: The data pump conventional export/import method is simple to implement, provides the broadest cross-platform support and enables you to physically re-organize your target database; however, the time and resources required for export and import may rule out this approach for situations with large databases or limited timeframes. E: Remote cloning is not supported in this scenario. https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/mig-11g-11g.html
Topics
Community Discussion
No community discussion yet for this question.