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…
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)- A2% (1)
- B10% (4)
- C12% (5)
- D71% (30)
- E5% (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
Community Discussion
No community discussion yet for this question.