Select the most appropriate migration method to meet th…

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.

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.

A.
Data Pump TDB

B.
Data Pump TTS

C.
SQL*Loader Direct Path

D.
conventional export/import

E.
Remote Cloning

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 reorganize 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



Leave a Reply 0

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