OCP-1Z0-053-V13.02-633题

633.Which three statements must be true before transporting a tablespace from a database on one platform to a database on another platform? (Choose three.)

A. Both source and target database must be the same character set

B. Both source and target database must have the same endian format

C. The COMPATIBLE parameter must be the same in the source and target databases.

D. The minimum compatibility level for both the source and target database must be 10.0.0.

E. All read-only and offline data files that belong to the tablespace to be transported must be platform aware.

Answer: ABD

答案解析：

参考：http://docs.oracle.com/cd/E11882_01/server.112/e25494/tspaces.htm#ADMIN11396

To import a transportable tablespace set into an Oracle database on a different platform, both databases must have compatibility set to at least 10.0.0. 

Table 14-1 Minimum Compatibility Requirements

Transport ScenarioMinimum Compatibility SettingSource DatabaseDestination Database

Databases on the same platform

8.0

8.0

Tablespace with different database block size than the destination database

9.0

9.0

Databases on different platforms

10.0

10.0

The database character sets of the source and the target databases are the same.

If the source platform and the destination platform are of different endianness, then an additional step must be done on either the source or destination platform to convert the tablespace being transported to the destination format. If they are of the same endianness, then no conversion is necessary and tablespaces can be transported as if they were on the same platform.

Before a tablespace can be transported to a different platform, the data file header must identify the platform to which it belongs. In an Oracle Database with compatibility set to 10.0.0 or later, you can accomplish this by making the data file read/write at least once.