Which of the following are prerequisite steps to transport a database? (Choose all that apply.)
A.
Query the V$TRANSPORTABLE_PLATFORMS view in the source database to determine if the
intended destination is listed.
B.
Verify that there are no restrictions or limitations that the source or destination database may
encounter.
C.
Verify that the source and destination have the same Oracle version, critical updates, patch-set
version, and patch-set exceptions.
D.
Determine if you will perform the conversion on the source or destination platform.
E.
None of the above.
In A correct view name is V$DB_TRANSPORTABLE_PLATFORM
http://docs.oracle.com/cd/E11882_01/server.112/e40402/dynviews_1109.htm
V$TRANSPORTABLE_PLATFORMS it is correct name of the view.
“V$TRANSPORTABLE_PLATFORM displays all platforms that support cross-platform tablespace transport. Specifically, it lists all platforms supported by the RMAN CONVERT TABLESPACE command, along with the endianness of each platform.”
See:
http://docs.oracle.com/cd/E18283_01/server.112/e17110/dynviews_3116.htm
D.
You can use the following query to determine the database platform and endian format of source and target databases:
select d.platform_name, t.endian_format
from v$database d, v$transportable_platform t
where d.platform_id=t.platform_id;
V$TRANSPORTABLE_PLATFORMS is incorrect, V$TRANSPORTABLE_PLATFORM is correct one (no S in the end).
A is wrong. Have to use the view V$DB_TRANSPORTABLE_PLATFORM.
C should not be considered too? For me B,C and D are correct.
V$TRANSPORTABLE_PLATFORM displays all platforms that support cross-platform tablespace transport.
V$DB_TRANSPORTABLE_PLATFORM displays all platforms to which the database can be transported using the RMAN CONVERT DATABASE command. The transportable database feature only supports transports of the same endian platform. Therefore, V$DB_TRANSPORTABLE_PLATFORM displays fewer rows than V$TRANSPORTABLE_PLATFORM.
For me B, C, D are correct too. Thanks Helcio!