Oracle Database Administration II — Question 100

You want to transport the UNIVERSITY tablespace from one database to another.
The UNIVERSITY tablespace is currently open read/write.
The source and destination platforms have the same endian format.
Examine this list of steps:
1. Make the UNIVERSITY tablespace read-only on the source system.
2. Export the UNIVERSITY tablespace metadata using EXPDP.
3. Create a cross-platform backup set from the UNIVERSITY tablespace on the source system, using an RMAN command that includes the DATAPUMP clause.
4. Copy the cross-platform backup sets to the destination system.
5. Copy the Data Pump dump set from the source to the destination system.
6. Restore the cross-platform backup set on the destination system using an RMAN command that includes the DATAPUMP clause.
7. Import the UNIVERSITY tablespace metadata using IMPDP.
8. Make the UNIVERSITY tablespace read/write on the destination system.
Which are the minimum number of steps required, in the correct order, to transport the UNIVERSITY tablespace?

Answer options

• A. 1, 3, 4, 6, 8
• B. 3, 4, 6
• C. 1, 2, 3, 4, 5, 6, 7, 8
• D. 2, 3, 4, 5, 6, 7

Correct answer: A

Explanation

The correct answer is A because it includes making the tablespace read-only, creating a cross-platform backup set, transferring that backup to the destination, restoring it, and finally making the tablespace writable again. Options B and D are incomplete as they lack the necessary steps to make the tablespace read-only and to import the metadata. Option C includes unnecessary steps that are not required for the minimum process.