What four migration methods can be used?

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?

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



Leave a Reply 1

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