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…

Question

Options

• Aconventional export/import
• BTransportable Tablespace (TTS) with RMAN conversion
• CTransportable Tablespace (TTS) by using Oracle Data Pump
• DSQL *Loader
• ERMAN image restore
• FData Pump Transportable Database (TDB) export/import

• A
  19% (5)
• B
  73% (19)
• E
  8% (2)

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 SQLLoader 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 SQLPlus, 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

No community discussion yet for this question.