You are migrating an Oracle Database 11.2.0.4 on-premise database to an Oracle Database Cloud Service (Database as a Service) that provides a pre-created
Oracle Database 12.1.0.2 database.
What four migration methods can be used?
A.
conventional export/import
B.
Transportable Tablespace (TTS) with RMAN conversion
C.
Transportable Tablespace (TTS) by using Oracle Data Pump
D.
SQL *Loader
E.
RMAN image restore
F.
Data Pump Transportable Database (TDB) export/import
Explanation:
You load data into an Oracle database on Oracle Database Cloud Service using the same tools you would use for an Oracle database on another system.
* (D) Using SQL*Loader to Load Data into the Database
* Using Oracle Data Pump Import to Load Data into the Database
* (BC) Using Transportable Tablespaces to Load Data into the Database
There are two ways to transport a tablespace:
Manually, involving issuing commands to SQL*Plus, RMAN, and Data Pump.
Using the Transport Tablespaces Wizard in Enterprise Manager
* Using Pluggable Databases (PDBs) to Load Data into the Database
* Using Oracle Public Cloud Data Transfer Services to Move Large Data Sets
* (F) Full transportable export/import, is available to make migration to Oracle Database 12c faster, easier, and more efficient than ever before. Full transportable
export is available starting with Oracle Database 11g Release 2 (11.2.0.3).
https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/load-data-db.html
https://docs.oracle.com/cd/B28359_01/server.111/b28310/tspaces013.htm#ADMIN11395
http://www.oracle.com/technetwork/database/enterprise-edition/full-transportable-wp-12c-1973971.pdf
A,B,C,F
https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/mig-11g-12c.html
– Data Pump Conventional Export/Import (A)
– Data Pump Transportable Tablespace (C)
– RMAN CONVERT Transportable Tablespace with Data Pump (B)
– Data Pump Full Transportable (F)