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:
TheData Pump Transportable Tablespacecan 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.
B
B
B