1Z0-067 · Question #117
You want to export the pluggable database (PDB) hr pdb1 from the multitenant container database (CDB)CDB1 and import it into the cdb2 CDB as the emp_pdb1 PDB. Examine the list of possible steps…
The correct answer is A. 2, 1, 3, 7, 6, and 8. Because the step 2 says that you perfom an expdp with the full clause and you dont need to create the tablespaces when you perform the impdp. FULL=yes will export tablespace definitions. So no need step 9. https://docs.oracle.com/cd/B10501_01/server.920/a96652/ch01.htm
Question
You want to export the pluggable database (PDB) hr pdb1 from the multitenant container database (CDB)CDB1 and import it into the cdb2 CDB as the emp_pdb1 PDB. Examine the list of possible steps required to perform the task:
1.Create a PDB named emp_pdb1. 2.Export the hr_pdb1 PDB by using the full clause. 3.Open the emp_pdb1 PDB. 4.Mount the emp_pdb1 PDB. 5.Synchronize the emp_pdb1 PDB in restricted mode. 6.Copy the dump file to the Data Pump directory. 7.Create a Data Pump directory in the emp_pdb1 PDB. 8.Import data into emp_pdb1 with the full and remap clauses. 9.Create the same tablespaces in emp_pdb1 as in hr_pdb1 for new local user objects. Identify the required steps in the correct order.
Options
- A2, 1, 3, 7, 6, and 8
- B2, 1, 4, 5, 3, 7, 6, 9, and 8
- C2, 1, 3, 7, 6, 9, and 8
- D2, 1, 3, 5, 7, 6, and 8
How the community answered
(30 responses)- A70% (21)
- B10% (3)
- C17% (5)
- D3% (1)
Explanation
Because the step 2 says that you perfom an expdp with the full clause and you dont need to create the tablespaces when you perform the impdp. FULL=yes will export tablespace definitions. So no need step 9. https://docs.oracle.com/cd/B10501_01/server.920/a96652/ch01.htm
Topics
Community Discussion
No community discussion yet for this question.