nerdexam
Oracle

1Z0-497 · Question #18

Which tool is recommended for moving a PDB to a non-CDB?

The correct answer is D. Data Pump. https://docs.oracle.com/database/121/SUTIL/dp_overview.htm#SUTIL4334 Using Data Pump with CDBs A multitenant container database (CDB) is an Oracle database that includes zero, one, or many user-created pluggable databases (PDBs). A PDB is a portable set of schemas, schema…

Storage Configuration

Question

Which tool is recommended for moving a PDB to a non-CDB?

Options

  • ARMAN
  • BCold Backup
  • CTraditional Export / Import
  • DData Pump
  • ESQL*Plus

How the community answered

(42 responses)
  • A
    2% (1)
  • B
    10% (4)
  • C
    12% (5)
  • D
    71% (30)
  • E
    5% (2)

Explanation

https://docs.oracle.com/database/121/SUTIL/dp_overview.htm#SUTIL4334 Using Data Pump with CDBs A multitenant container database (CDB) is an Oracle database that includes zero, one, or many user-created pluggable databases (PDBs). A PDB is a portable set of schemas, schema objects, and non schema objects that appear to an Oracle Net client as a non-CDB. A non-CDB is an Oracle database that is not a CDB. You can use Data Pump to migrate all, or portions of, a database from a non-CDB into a PDB, between PDBs within the same or different CDBs, and from a PDB into a non-CDB. In general, using Data Pump with PDBs is identical to using Data Pump with a non-CDB. In Oracle Database 12c Release 1 (12.1), Data Pump does not support any CDB-wide operations. Data Pump issues the following warning if you are connected to the root or seed database of a CDB: ORA-39357: WARNING: Oracle Data Pump operations are not typically needed when connected to the root or seed of a container database. 1. Transportable Tablespace (this is the smoothest way) 2. Data Pump full export/import 3. Other logical migration ways like Oracle GoldenGate

Topics

#PDB migration#non-CDB#Data Pump#database portability

Community Discussion

No community discussion yet for this question.

Full 1Z0-497 Practice