Examine the list of possible steps to transport a tablespace across platforms that have the same compatibility level, character sets, and endian format:
1. Make the tablespace read-only at the source database.
2. Export metadata from the source database.
3. Import metadata into the target database.
4. Transfer the dump file and data files to the target machine.
5. Convert data files by using Recovery Manager (RMAN).
6. Make the tablespace read-write at the target database.
Identify the required steps in the correct order.
A.
2, 4, and 3
B.
2, 4, 3, and 5
C.
1, 5, 2, 4, 3, and 6
D.
1, 2, 4, 3, and 6
Explanation:
Step 1 (1) : To copy tablespaces from one database to another using transportable tablespace, the source tablespaces are first kept in READ-ONLY mode (to ensure data consistency). Once the tablespaces are in READ-ONLY mode, the actual datafiles belonging to the source tablespaces are copied from source database to target database (using any available methods like scp, sftp, rcp, etc).
Step 2 (2): Once the tablespace is kept in READ-ONLY mode, we need to generate the metadata export of the tablespaces that needs to transported using the DataPump export utility.
Step 3 (4): Once the metadata export is generated on the source database for all the tablespaces that needs to be transported, we need to copy theExport Dump file as well as all the datafiles belonging to the tablespaces to be transported to the target database server.References: http://www.oraclebuffer.com/oracle/migrate-oracle-database-using-transportable-tablespace/